Subject Listing all the user security on entities in the database
Author samcarleton
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?