OraFAQ Forum: Server Administration » Privileges on views and subprograms

Home » RDBMS Server » Server Administration » Privileges on views and subprograms

Tue, 26 June 2001 06:00

Uday
Messages: 21
Registered: December 2000

Junior Member

Dear All,
How can one get the list of priviliges made on objects(tables, views, subprograms) to other users in the same database.
Uday

Wed, 27 June 2001 17:01

Lars Sjöström
Messages: 24
Registered: June 2001

Junior Member

Search DICT for the word privilige and I think you will find the table (or view) there. i.e.

SELECT * FROM DICT where comments like '%priv%';

Previous Topic:	Pl/Sql server pages
Next Topic:	How to get the abstract data type values

Goto Forum:

]

Current Time: Sat Jul 06 07:54:04 CDT 2024