Home » RDBMS Server » Server Administration » granting select on all tables
granting select on all tables [message #167680] Sat, 15 April 2006 06:09 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
I wanted to grant one user select on all tables on scott, in single query, is it possible?

Report message to a moderator

Re: granting select on all tables [message #167698 is a reply to message #167680] Sat, 15 April 2006 09:02 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> in single query, is it possible?
No, but it can be done in two lines; not 1.

Report message to a moderator

Re: granting select on all tables [message #167784 is a reply to message #167680] Mon, 17 April 2006 01:52 Go to previous message
orajamzs
Messages: 110
Registered: February 2006
Location: hyderabad
Senior Member

Grant select any table to scott;

Report message to a moderator

Previous Topic: difference Patch, Patchset and Minipack ??????????
Next Topic: developer 2000 in oracle 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:29:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.