Home » RDBMS Server » Security » ORACLE SECURITY - URGENT!!
ORACLE SECURITY - URGENT!! [message #54264] Thu, 07 November 2002 12:00 Go to next message
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 #54271 is a reply to message #54264] Fri, 08 November 2002 00:36 Go to previous messageGo to next message
gp
Messages: 46
Registered: September 2002
Member
i dont see any risk as such it all depends what all user privlages u give
Re: ORACLE SECURITY - URGENT!! [message #54276 is a reply to message #54264] Fri, 08 November 2002 03:46 Go to previous message
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
Previous Topic: which role, grant is given to which user
Next Topic: GRANT inside procedure
Goto Forum:
  


Current Time: Fri Mar 29 04:15:05 CDT 2024