OraFAQ Forum: SQL & PL/SQL » How to fetch several values at a time...

Home » SQL & PL/SQL » SQL & PL/SQL » How to fetch several values at a time...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to fetch several values at a time... [message #257742]

Thu, 09 August 2007 02:01

hedonist123
Messages: 119
Registered: August 2007

Senior Member

Hey everyone,

This is the problem I face...

Someone has granted select, insert and references as three privileges to a user on a table.

Now I wish to extract the code used to write this statement in this format

'grant' || insert, references, select || 'on' || table_name || 'to'
|| user;

Insert alone can be passed from the privilege column in user_tab_privs, however, references and select are separate entries in the table.. how do I pass them so I can get the statement as above.

Thanks...

Sharath

Report message to a moderator