Re: making super admin account for specific tablespace

ashu wrote:
> i want to convert a user acoount into super admin for a specific
> tablespace. i know how to create user accounts using oracle enterprise
> manager and sql. but a super admin account i never create.kinldy help?
>

There is no such thing as a super admin account for a tablespace. A user can either create a segment (i.e. table or index) in the tablespace or it cannot. This is controlled by the user's quota on that tablespace. The quota can be defined with the ALTER USER command (http://tahiti.oracle.com).

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com