Home » SQL & PL/SQL » SQL & PL/SQL » how to give privileges to synonyms
icon2.gif  how to give privileges to synonyms [message #183552] Fri, 21 July 2006 05:20 Go to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
how to give privileges to synonyms in database?is it possible?
Re: how to give privileges to synonyms [message #183557 is a reply to message #183552] Fri, 21 July 2006 05:59 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

 are you referring about public synonym


regards,
Re: how to give privileges to synonyms [message #183558 is a reply to message #183552] Fri, 21 July 2006 06:08 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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?
Re: how to give privileges to synonyms [message #183561 is a reply to message #183560] Fri, 21 July 2006 06:28 Go to previous messageGo to next message
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
Re: how to give privileges to synonyms [message #183568 is a reply to message #183561] Fri, 21 July 2006 06:59 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
i am getting error while granting create synonym privilege
Re: how to give privileges to synonyms [message #183572 is a reply to message #183568] Fri, 21 July 2006 07:12 Go to previous messageGo to next message
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.
Re: how to give privileges to synonyms [message #183576 is a reply to message #183572] Fri, 21 July 2006 07:19 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
i am having the SYSDBA privilege but still am not able to do it
Re: how to give privileges to synonyms [message #183578 is a reply to message #183576] Fri, 21 July 2006 07:28 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
so you are logged in as sys?
Re: how to give privileges to synonyms [message #183581 is a reply to message #183578] Fri, 21 July 2006 07:40 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
yes i am
Re: how to give privileges to synonyms [message #183594 is a reply to message #183581] Fri, 21 July 2006 08:23 Go to previous messageGo to next message
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.
Re: how to give privileges to synonyms [message #183814 is a reply to message #183568] Mon, 24 July 2006 01:13 Go to previous messageGo to next message
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
Re: how to give privileges to synonyms [message #183820 is a reply to message #183814] Mon, 24 July 2006 01:24 Go to previous message
William Robertson
Messages: 1640
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.
Previous Topic: Tracing PL/SQL Code
Next Topic: in function how to use v$parameter
Goto Forum:
  


Current Time: Fri Dec 09 23:29:45 CST 2016

Total time taken to generate the page: 0.10021 seconds