Re: SYSTEM as SYSDBA cannot grant privs on others' tables?

Hi!

What you missing is to create a password file which allows granting sysdba, sysoper
priviliges to more than one user.

Use orapwd file=<$ORACLE_HOME>/dbs/orapw<$ORACLE_SID> password=<just a password> entries=10 for Unix.
The corresponding utility for NT is oradim80.

After that you can grant sysadm to any user you have created. To do so connect to the server manager as sys:
connect sys as sysdba and
grant sysdba to <your user>

Regards,

Alex

"Jim Garrison" <jhg_at_acm.org> wrote in message news:397B8A37.6F93FB16_at_acm.org...
> I'm trying to set up a complex set of schemas and want to do
> all the work logged on as SYSTEM. I can create tables in
> other schemas, but when I try to grant privileges on those
> tables (to PUBLIC, for instance) Oracle tells me I have
> insufficient privileges. For example:
>
> grant select on mfg.orders to public;
> ORA-01031: insufficient privileges
>
> I'm logged on as SYSTEM. It makes no difference if I use
> "as SYSDBA" also. As far as I can tell, SYSTEM has all
> necessary privileges.... what am I missing?
>
> --
> Jim Garrison (jhg_at_acm.org)
> PGP Keys at http://www.acm.org/~jhg RSA 0x04B73B7F DH 0x70738D88
Received on Wed Jul 26 2000 - 00:00:00 CDT