The oracle database, create a user, let he only modify, execute the stored procedure and query the database permissions

CodePudding user response:

It will have to be to connect and create procedure jurisdiction,

However, it may has the authority to create table;

CodePudding user response:

The create table permissions have another give
Just to CONNECT privileges, cannot be built table

Can give the CONNECT permissions

SQL> Grant create any procedure to u1.

Authorization is successful,

SQL> Grant alter any procedure to u1.

Authorization is successful,

SQL> Grant drop any procedure to u1.

Authorization is successful,

SQL> The create or replace procedure test_proc
2 as
3 the begin
4 null;
5 the end;
6/

Process has been created,

SQL> The exec test_proc;

PL/SQL procedure successfully completed,

CodePudding user response:

Query the database access, this is the concept of mysql,
Whose table oracle, query, query, own, or other,
If it is your own, that can change table to read-only table
If other users, can be done by other users to give him authorization