Home » SQL & PL/SQL » SQL & PL/SQL » How to fetch several values at a time...
How to fetch several values at a time... [message #257742] Thu, 09 August 2007 02:01 Go to next message
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
Re: How to fetch several values at a time... [message #257783 is a reply to message #257742] Thu, 09 August 2007 03:03 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is one line per privilege in dictionary.
Why do want only 1 statement and not 3?

Regards
Michel
Previous Topic: How to drop more than one column at a time
Next Topic: I need a design idea / querying hierarchical model (merged by LF)
Goto Forum:
  


Current Time: Sun Dec 04 10:58:54 CST 2016

Total time taken to generate the page: 0.13609 seconds