Re: DBA privileges

hi ....
some of the resources even if you have been granted as DBA cannot be accessed ... so
you must have granted acces by the user sys do the following
sql > conn sys/<sys_password>@SID
sql> grant all on DBMS_SPACE to <user name >

now you can acess the dbms function.

tec26t_at_my-deja.com wrote:

> Hi,
>
> With the current privileges granted to me on my
> "DBA" account, I can run various dbms functions
> but cannot run a handful. I'm trying to use
> dbms_space.unsued_space and get the following
> error:
>
> ORA-01031: insufficient privileges
> ORA-06512: at "SYS.DBMS_SPACE", line 37
> ORA-06512: at line 10
>
> However, I can use dbms_snapshot etc without
> problems. Any suggestions ?
>
> Regards
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 29 1999 - 02:19:02 CST