Re: Objects ownership in Oracle !!!

From: Ken Geng <ken.geng_at_cbis.com>
Date: 1997/02/17
Message-ID: <3308B15D.4929@cbis.com>#1/1

Lun Wing San (Oracle) wrote:
- In general,
-

There is an user who owns all objects for an application. However, it does not have
create session privilege to ensure no auditing option can be set on it. Thus, it
prevents from the allocations of all extents for auditing tables.
-
There is a role to have select privileges on the application objects.
-
The application users will have create session and execute procedure privileges only.
-
Any privilege and role grantings are done by the schema owner rather than DBA to ease
of maintenance.

Can you explain a bit further on how a user without create session privilege grants roles/privileges to other users?

Thanks,

Ken. Received on Mon Feb 17 1997 - 00:00:00 CST