OraFAQ Forum: Security » Grant the rights to other database user

Home » RDBMS Server » Security » Grant the rights to other database user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Grant the rights to other database user [message #9467]

Wed, 12 November 2003 21:52

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

Report message to a moderator

Re: Grant the rights to other database user [message #9479 is a reply to message #9467]

Fri, 14 November 2003 05:09

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.

Report message to a moderator

Previous Topic:	Encryption
Next Topic:	connect/password question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 03 01:35:49 CDT 2025