GRANT authorization, grant authorization

GRANT authorization, grant authorization

Log On As the sys (Administrator) and create the username zsta_new

Create user zsta_new
Identified by password
Default tablespace ZSTA_DATA_TBS
Temporary tablespace TEMP
Profile DEFAULT;

Authorize zsta_new users (allow creation of 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;

Assume that the zsta_new user creates a stored procedure up_xx_gzmx and allows the smxxpt user to call

Log On As the zsta_new user and execute the following statement:

Grant execute on up_xx_gzmx to smxxpt

Refer:

As we all know, grant permissions are granted to other users. He 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 table permissions:

Grant select/update on table to user;

Grant permission on table to user.

2. grant the Stored Procedure permissions:

Grant execute on package/function/procedure to user;

Grant execute on process, package, method to user