Home » RDBMS Server » Security » PL/SQL- Grant Object Privilages
PL/SQL- Grant Object Privilages [message #38751] Sat, 11 May 2002 06:19 Go to next message
bharath
Messages: 30
Registered: November 2000
Member
How to grant object privilages through a procedure
Re: PL/SQL- Grant Object Privilages [message #38753 is a reply to message #38751] Sat, 11 May 2002 17:23 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
execute immediate 'grant select on ' || p_tablename || ' to ' || p_username;
Previous Topic: connect as sysdba
Next Topic: Oracle generating audit & trace files when auditing/tracing not specified
Goto Forum:
  


Current Time: Thu May 26 15:05:06 CDT 2022