Re: create user with global rights ..?

Hi MD,

I don't know the history of this thread but the answer to your question is "thank goodness" :)

You should never attempt to update sys objects directly (unless you really really know what you're doing) but a user with DBA privileges alone will not be able to touch them anyway (assuming you're on anything above Oracle7 with O7_DICTIONARY_ACCESSIBILITY=false) as the ANY privilege set doesn't include objects in the SYS schema (and your example is a classic as to why this is so).

I'm sure Howard was not suggesting the DBA role has sysdba privileges. Cheers

Richard

Md Irfan wrote:
>
> "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.