OraFAQ Forum: SQL & PL/SQL » how to give privileges to synonyms

Home » SQL & PL/SQL » SQL & PL/SQL » how to give privileges to synonyms

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

how to give privileges to synonyms [message #183552]

Fri, 21 July 2006 05:20

amul
Messages: 252
Registered: April 2001
Location: Chennai

Senior Member

how to give privileges to synonyms in database?is it possible?

Report message to a moderator

Re: how to give privileges to synonyms [message #183557 is a reply to message #183552]

Fri, 21 July 2006 05:59

dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai

Senior Member

hi,

 are you referring about public synonym

regards,

Report message to a moderator

Re: how to give privileges to synonyms [message #183558 is a reply to message #183552]

Fri, 21 July 2006 06:08

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Technically, the only things that have privileges are Users or Roles.

You can grant SELECT, UPDATE & DELETE on a synonym to a user or role, but this will also grant the same privileges on the object the synonym points to.

[Updated on: Fri, 21 July 2006 06:27]

Report message to a moderator

Re: how to give privileges to synonyms [message #183560 is a reply to message #183557]

Fri, 21 July 2006 06:27

amul
Messages: 252
Registered: April 2001
Location: Chennai

Senior Member

ya am referring to public synonym,but its saying insufficient privileges.is there any create synonym privilege available?

Report message to a moderator

Re: how to give privileges to synonyms [message #183561 is a reply to message #183560]

Fri, 21 July 2006 06:28

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Are you getting the error trying to create the synonym, or trying to use the synonym? Clarity is always helpful.

To create a synonym, you need the privilige CREATE SYNONYM.

To create a public synonym, you need the priv. CREATE PUBLIC SYNONYM

Report message to a moderator

Re: how to give privileges to synonyms [message #183568 is a reply to message #183561]

Fri, 21 July 2006 06:59

amul
Messages: 252
Registered: April 2001
Location: Chennai

Senior Member

i am getting error while granting create synonym privilege

Report message to a moderator

Re: how to give privileges to synonyms [message #183572 is a reply to message #183568]

Fri, 21 July 2006 07:12

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

That means that the user you are using to grant the privilege does not have that privilege with the "WITH ADMIN OPTION" specified.

Report message to a moderator

Re: how to give privileges to synonyms [message #183576 is a reply to message #183572]

Fri, 21 July 2006 07:19

amul
Messages: 252
Registered: April 2001
Location: Chennai

Senior Member

i am having the SYSDBA privilege but still am not able to do it

Report message to a moderator

Re: how to give privileges to synonyms [message #183578 is a reply to message #183576]

Fri, 21 July 2006 07:28

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

so you are logged in as sys?

Report message to a moderator

Re: how to give privileges to synonyms [message #183581 is a reply to message #183578]

Fri, 21 July 2006 07:40

amul
Messages: 252
Registered: April 2001
Location: Chennai

Senior Member

yes i am

Report message to a moderator

Re: how to give privileges to synonyms [message #183594 is a reply to message #183581]

Fri, 21 July 2006 08:23

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Step 1) Stop logging in as sys. It's not intended to be used for things other than DB maintenance

Step 2) Log in as another DBA account, repeat what you are trying to do, and post the SQL and the results here.

Report message to a moderator

Re: how to give privileges to synonyms [message #183814 is a reply to message #183568]

Mon, 24 July 2006 01:13

pamrajrajeev
Messages: 9
Registered: July 2006

Junior Member

Hai,

it means that u don't have sufficient priviliges. its better to do from admn or else dba has to grant u create privilieges with grant option.

ragards

rajeev

Report message to a moderator

Re: how to give privileges to synonyms [message #183820 is a reply to message #183814]

Mon, 24 July 2006 01:24

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

Look up CREATE SYNONYM in the documentation. Check the "Prerequisites" section.

Note that this has nothing to do with giving privileges to synonyms.

Report message to a moderator

Previous Topic:	Tracing PL/SQL Code
Next Topic:	in function how to use v$parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 10 01:44:26 CST 2024