This content has been marked as final. Show 5 replies
REDO LOG wrote:what happens when you try it?
suppose that we have two users peter and kim
kim has a customers table on his schema, can system grant the select privilege on kim.customers to peter?
thanks for help
How do I ask a question on the forums?
SQL and PL/SQL FAQ
the user get the concerned privilege but it supposed to not happen,
The answer is version-dependent though it would be true for all currently supported releases.
As I recall it was 9i Release 2 that introduced the GRANT ANY OBJECT PRIVILEGE and this privilege allows a non-owner to grant privileges on the object in question.
For example, here's some text from the 11.2 SQL Language Reference on the GRANT command:
You can probably dig around for confirmation if it was in fact 9i R2 that introduced this, but that should really be immaterial at this point in time.
GRANT ANY OBJECT PRIVILEGE: Grant any object privilege that the object owner is permitted to grant. Revoke any object privilege that was granted by the object owner or by some other user with the GRANT ANY OBJECT PRIVILEGE privilege.
I actually use the 10.2.0.1.0 version, In an exam paper, I asks to do what I said in the question and report the consequences, then I another question it asks to connect under kim and grant the select privilege on the customers to peter, so I wondered that in the first try i.e. granting the privilege under system would cause insufficient privileges..
Also you can use
create public synonym <synonym name> for Schema.Table