Home » SQL & PL/SQL » SQL & PL/SQL » how to grant privilege on another schema to a user (Oracle 8i)
how to grant privilege on another schema to a user [message #285553] Wed, 05 December 2007 00:47 Go to next message
zeekhan
Messages: 1
Registered: December 2007
Location: Multan, Pakistan
Junior Member

hi,

I've created a user temp and now i want to grant select privilege to temp on all tables of admin user. I don't know how to do this. can any1 help me in this case?

thanx

zeeshan
Re: how to grant privilege on another schema to a user [message #285555 is a reply to message #285553] Wed, 05 December 2007 00:50 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>I don't know how to do this. can any1 help me in this case?
There is "grant" command to grant previleges to users.
http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_9013.htm#SQLRF01603
Previous Topic: Newbie error with IF Statement in SELECT
Next Topic: selection in columns
Goto Forum:
  


Current Time: Sat Dec 10 22:50:24 CST 2016

Total time taken to generate the page: 0.10574 seconds