Subject | Listing all the user security on entities in the database |
---|---|
Author | samcarleton |
Post date | 2010-12-08T12:31:09Z |
So far my app has been pretty simple so I took the lazy approach and simply let the app use sysdba, but I just moved the DB to a real server so I want to start using a real user. I already have the user and some of the tables, views and stored procs have granted the user privileges, some have not. Now I would like to get a list of what does have user privileges and what doesn't. Is there an easy way to do that?
Sam
Sam