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

Report message to a moderator

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;

Report message to a moderator

Previous Topic: connect as sysdba
Next Topic: Oracle generating audit & trace files when auditing/tracing not specified
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 08:15:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.