Hi,
I have created a USER and want to give rights to this USER to access tables, procedures from another schema.
The user should have rights only to read, write, delete, insert records, execute procedure.
User should not be allowed to create/drop table.
How can I do this as I am new to DBA.
TIA,
RAJ
I have created a USER and want to give rights to this USER to access tables, procedures from another schema.
The user should have rights only to read, write, delete, insert records, execute procedure.
User should not be allowed to create/drop table.
How can I do this as I am new to DBA.
TIA,
RAJ