| why i cant create synonym [message #296493] |
Sun, 27 January 2008 23:40  |
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
|
Senior Member |
|
|
Hi Friends,
Here I have user 'NVS' on his login i can access table like this query.
Select * from accl.all_master
but cant all_master
it said table_view does not exist
For that i Want to create synonym for the accl.all_master
when i try the below statament
create synonym all_master for accl.all_master
im getting insufficient privileges.
What privilege i want to provide for the user 'NVS'
for create the synonym.
but all_master is an view
Thank in advance
wbr
Kanish
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: why i cant create synonym [message #296547 is a reply to message #296546] |
Mon, 28 January 2008 02:46  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
OP,
Actually "connect" is role with many privileges.
SQL> grant connect to a;
Grant succeeded.
SQL> conn a/a@db1
Connected.
SQL> select * from session_privs;
PRIVILEGE
----------------------------------------
CREATE SESSION
ALTER SESSION
CREATE TABLE
CREATE CLUSTER
CREATE SYNONYM
CREATE VIEW
CREATE SEQUENCE
CREATE DATABASE LINK
8 rows selected.
It is not recommended to grant "connect" role to directly database user always better to grant explicitly required privileges.
PS: In my previous post i was show two way to grant "create synonym" privileges but it is not recommended to grant "connect" role directly so i apologize for that.
[Updated on: Mon, 28 January 2008 02:46] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
