Re: Why can't user with DBA rights add datafile to tablespace?

From: John Koo <johnkoo_at_i-wave.net>
Date: Wed, 20 Jan 1999 13:27:45 +0000
Message-ID: <36A5D9D1.EE821391@i-wave.net>

Adrian Harrison wrote:

> Have a user with DBA rights but can't add a datafile to a tablespace! - have to login as "System"
> user to do this!
>
> What rights do I have to assign so that they can do this themselves?
>
> Thanks
>
> A.H

Are you sure that user "oracle" has permission to the underlying directory ??? Are you sure oracle executable file in $ORACLE_HOME/bin is owned by "oracle" ?? Are you sure the setuid bit is turned on for oracle executable ?? Are you sure the user performing the "ALTER TABLESPACE" has the right db privilege ?? Try "SELECT * FROM SESSION_ROLES;" to make sure that the user has required privs. The BDA users usually has the following privs:

SQL> select * from session_roles;

ROLE

---

CONNECT
DBA
SELECT_CATALOG_ROLE
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
EXP_FULL_DATABASE
IMP_FULL_DATABASE
TKPROFER 8 rows selected.

John Koo
johnkoo_at_i-wave.net Received on Wed Jan 20 1999 - 07:27:45 CST