Grant authorization

Log in as sys (administrator) and create the user name zsta_new

Create user zsta_new

Identified by password

Default tablespace ZSTA_DATA_TBS

Temporary tablespace TEMP

Profile DEFAULT; authorizes zsta_new users (allows you to create stored procedures, etc.):

Grant connect to zsta_new

Grant resource to zsta_new

Grant create any procedure to zsta_new

Grant create any view to zsta_new

Grant unlimited tablespace to zsta_new

Grant create database link to zsta_new

Grant debug any procedure, debug connect session to zsta_new; assumes that the zsta_new user creates a stored procedure up_xx_gzmx and allows the smxxpt user to call

Then log in as the zsta_new user and execute the following statement:

Grant execute on up_xx_gzmx to smxxpt reference:

It is well known that grant assigns permissions to other users. It can not only grant permissions to tables and views, but also to stored procedures, methods, and packages. The specific syntax is as follows:

1.grant assigns permissions to the table:

Grant select/update on table to user

Grant permissions on table to user.

2.grant assigns permissions to stored procedures:

Grant execute on package/function/procedure to user

Grant execute on procedure, package, method to user

-

Copyright notice: this article is the original article of CSDN blogger Wan Ruiqing, in accordance with the CC 4.0BY-SA copyright Agreement. Please attach the original source link and this statement for reprint.

Original link: https://blog.csdn.net/gateway6143/article/details/41212823