OraFAQ Forum: Server Administration » grant of create any synonym on a user via DB link

Home » RDBMS Server » Server Administration » grant of create any synonym on a user via DB link (oracle 11.2.0.1 RAC of two nodes,solaris10)

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

grant of create any synonym on a user via DB link [message #557234]

Mon, 11 June 2012 03:45

janakors
Messages: 232
Registered: September 2009

Senior Member

hi,

we are deploying an application and i need to give grant of create any synonym on a user which is in another DB , i have created a db link and working fine, Now i have user RMS in DB1 and another user GTR in DB2, i want to give create and select synonym right to RMS on GTR , how can i do that, i have checked the net but didn't find the exact syntax kindly guide and any link of any document which help me out or exact syntax

Report message to a moderator

Re: grant of create any synonym on a user via DB link [message #557242 is a reply to message #557234]

Mon, 11 June 2012 04:13

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Remote user has no privilege on local database.
Remote user inherits the privileges of the user that is declared in the db link it uses.

Regards
Michel

Report message to a moderator

Re: grant of create any synonym on a user via DB link [message #557255 is a reply to message #557242]

Mon, 11 June 2012 05:17

janakors
Messages: 232
Registered: September 2009

Senior Member

Thank You , Michel

Regards

Report message to a moderator

Previous Topic:	Change current redo log size in oracle mount stage
Next Topic:	how to get rowid

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 20:15:51 CST 2025