How to find Grants given on Synonyms. [message #213736] |
Fri, 12 January 2007 02:16  |
amkotz
Messages: 72 Registered: May 2005 Location: Bangalore
|
Member |
|
|
Hello All,
I have table in Database named Table_1. It has two synonyms built on it namely SYN1 AND SYN2.
Both the Synonyms has different Grants on it,
Lets Say SYN1 has SELECT and SYN2 has DELETE on it.
Both these synonyms are granted to different users in the Database.
Now how do i know that, to which synonyms what all has been granted.
like SYN1 has SELECT and SYN2 has DELETE.
Thanks in Advance,
Amkotz
|
|
|
|
Re: How to find Grants given on Synonyms. [message #213757 is a reply to message #213736] |
Fri, 12 January 2007 03:51   |
amkotz
Messages: 72 Registered: May 2005 Location: Bangalore
|
Member |
|
|
Hello tahpush
""Dont think you mean that the synonyms have different grants.""
The Synonyms have different grants. IS THIS POSSIBLE.( Two separate synonyms on the same table with different grants) ?
SYN1 has SELECT and SYN2 DELETE.
REGDS,
AMKOTZ
|
|
|
|
|
|