Home » RDBMS Server » Security » Grant the rights to other database user
Grant the rights to other database user [message #9467] Wed, 12 November 2003 21:52 Go to next message
Imran Khan
Messages: 6
Registered: May 2002
Junior Member
I have two databases (orc1 , orc2) and I created the service and db link of ora1 database in orc2. Now I want to give some object privileges orc1 from orc2 plz tell me the syntax and proper way - thanks
Re: Grant the rights to other database user [message #9479 is a reply to message #9467] Fri, 14 November 2003 05:09 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Create a local user with the appropriate privileges(& synonyms) on the tables of interest.
Create database link on the remote node to connect to the local database through this user.
Use the database link on the remote node to access the tables . It controls the privileges now.
Previous Topic: Encryption
Next Topic: connect/password question
Goto Forum:
  


Current Time: Thu Mar 28 15:10:29 CDT 2024