The USABLE_SPACES setting does not change DBA privileges. DBAs always have privileges to create objects on all dbspaces and dbslices. Any user who creates a database becomes the DBA for that database.
SET ENVIRONMENT can only be used to set the USABLE_SPACES value when you are connected to a database, and can only change the value for the current session.
The database server issues an error if a specified space does not exist ( -23552), or if a user who neither holds DBA privilege nor is the owner of the database attempts to reset an immutable USABLE_SPACES value ( -24143).
The database server does not check to see whether a space that is specified in a USABLE_SPACES setting is online and it does not prevent that dbspace or dbslice from being dropped. Other errors will occur, however, if there is an attempt to use them in those cases.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]