Re: User access rights

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 23 Jun 2006 10:30:11 -0700
Message-ID: <1151083811.491543.258270@g10g2000cwb.googlegroups.com>

Michel Cadot wrote:
> "Christian Schneider" <Dudeldd_at_gmx.de> a écrit dans le message de news: 449c1bd8$0$4500$9b4e6d93_at_newsread2.arcor-online.net...
> | Hi,
> |
> | any idea how I can get a table of all users and a table with
> | all access rights of a user?
> |
> | I know there is a system table that contains all this kind of
> | information, but I can't remember its name.
> |
> |
> | Chris
>
> http://download-west.oracle.com/docs/cd/B10501_01/nav/catalog_views.htm?remark=homepage#index-DBA
>
> Regards
> Michel Cadot

Here are two articles on the basic views of the Oracle RDBMS dictionary. The second article is dedicated to security views.

How do I find information about a database object: table, index, constraint, view, etc... in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html

How do I find out which users have the rights, or privileges, to access a given object ? http://www.jlcomp.demon.co.uk/faq/privileges.html

HTH -- Mark D Powell -- Received on Fri Jun 23 2006 - 12:30:11 CDT