No, you can't get who granted a particular role to a particulaar user. It is not recorded in a database dictionary. If you need to track that information then you'll have to turn on auditing on SYSTEM GRANT and get the information you need from audit trail.




Reply With Quote