Re: create user with global rights ..?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 6 Aug 2002 18:33:42 +1000
Message-ID: <aio1j5$q20$1@lust.ihug.co.nz>

Who is the owner of that table?

Wouldn't be SYS by any chance would it? (I only ask because I appear not to have such a table in my database, owned by anybody!)

If so, and as I explained earlier, if o7_dictionary_accessibility=false (the default in 9i) then the 'any' keyword doesn't apply to SYS-owned tables.

Regards
HJR "Md Irfan" <irfan_pk_at_hotmail.com> wrote in message news:c42168e7.0208052140.49e9a98_at_posting.google.com...
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:<aihd2c$6db$1_at_lust.ihug.co.nz>...
>
> >
> > Or you could simply 'grant dba to user', since the DBA role includes
these
> > same privileges
>
> what if a user is granted the dba role, but when trying to update the
> table global_name, results in insufficient privileges.
Received on Tue Aug 06 2002 - 03:33:42 CDT