Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle security roadmap

Oracle security roadmap

From: Ben <balvey_at_comcast.net>
Date: 16 Aug 2006 06:16:46 -0700
Message-ID: <1155734206.064371.232590@i42g2000cwa.googlegroups.com>


I in herited several 9.2.0.5 Ent Edition databases running on aix 5.2. The previous dba didn't keep any kind of documentation on security. So now I have a long list of users and roles and no real good idea of what role is for what user and how our security in general was approached. I created a couple of new tables the other day and then found out that the correct roles didn't have privledges granted accordingly and they couldn't been seen until I did that. I need to know how to get a good picture of our security setup. Is there a sql statement that is typically used to give a good outline or road map of a db security?

Thanks for any help
Ben Received on Wed Aug 16 2006 - 08:16:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US