DBA - Question - USER privilegs

From: Nandakumar <nanban_at_my-deja.com>
Date: Tue, 24 Aug 1999 20:29:54 GMT
Message-ID: <7puvbf$f76$1@nnrp1.deja.com>

What are the privileges that one user (yyy) should possess if he has to ONLY VIEW certain tables and views (owned by user xxx) and execute some sub programs?.

User yyyy should not be able to create any table in the DB.
User should not be able to use any DML except select.
Some of the user-defined sub programs (owned by xxxx) that 'yyyy' will invoke, use dynamic pl/sql. So 'yyyy' should be able to execute some of the sub programs from oracle standard packages, like DBMS_SQL etc.

Any suggestion is appreciated!
Thanks
--
Nandakumar
Systems Analyst
New York
(N.Kumar_at_rocketmail.com)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 24 1999 - 15:29:54 CDT