| role and privillages [message #132399] |
Fri, 12 August 2005 09:52  |
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
|
Member |
|
|
Hi.
i have a situation were a user says that he cannot execute the sql that he has been able to execute all along,he says his role/privillages have changed.Is there anyway i can see when(date&time) the roles/privillages where granted or revoked from the user.
|
|
|
|
| Re: role and privillages [message #132405 is a reply to message #132399] |
Fri, 12 August 2005 10:30  |
mbartov
Messages: 4
Registered: June 2005
Location: Dallas, TX
|
Junior Member |
|
|
The only way, I know of, you can find out when a privilege/role was granted or revoked is to use oracle logminer. You will be able see the timestamp when the table SYS.SYSAUTH$ was changed (insert/delete/update). If you need help how to use the logminer let me know.
Michel Bartov
http://www.odbtools.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
