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
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.


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: 65137
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?

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: Thu Aug 17 08:46:51 CDT 2017

Total time taken to generate the page: 0.07831 seconds