access to procedure from another schema

[rk68]

I have schema (say schema name A) which has multiple procedures & tables of clients with DBA rights.
I have created various users & have to give them access to the above schema.

a) How can I give access to a user to schema A
b) post giving access to the user, how can he execute the procedures of Schema A

TIA
RAJ

 

[LKBrwnDBA]

a) How can I give access to a user to schema A

Create role and grant permissions on A objects to the role -- then Grant role to users

b) post giving access to the user, how can he execute the procedures of Schema A

Grant execute on the procedure(s) to the role, and use format "{schema A}.proc_name" to execute it.

PS: If procedures perform dml on schema A tables, you need to grant "insert|update|delete" permissions on those tables directly to the user(s).



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb