ORACLE SECURITY - URGENT!! [message #54264] |
Thu, 07 November 2002 12:00 |
MARILOU
Messages: 2 Registered: November 2002
|
Junior Member |
|
|
Are there risks on public synonyms?
I understand that users with privileges to the
table can use the public synonyms.
My question is a synonym made public would allow
users privileges to the table?
I appreciate your quick answers.
Thanks.
|
|
|
|
Re: ORACLE SECURITY - URGENT!! [message #54276 is a reply to message #54264] |
Fri, 08 November 2002 03:46 |
B
Messages: 327 Registered: August 1999
|
Senior Member |
|
|
synonym are here to permit U to not full quantified a table name.
ie
if U create a public synonym TEST fo USER.TEST
all user who query TEST query USER.TEST
If U don't grant privileges to an USER1, he can not select, insert etc ... on this table.
WARNING: User with ANY TABLES privileges can use DML on ALL TABLES
|
|
|