Re: database privileges

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 22 Oct 2002 03:36:51 +1000
Message-ID: <UOWs9.58585$g9.167311@newsfeeds.bigpond.com>

Truly minimally, the only system privilege a user needs is 'create session'. After that, it's all object privileges to get any real work. And if you're really trying to pin security down, revoke absolutely everything from public.

Use the dba_sys_privs and ..._tab_privs views to work out what's already been assigned to that particular role.

Regards
HJR "mark" <oil1can_at_yahoo.com> wrote in message news:87eb0424.0210210839.2e55bcb0_at_posting.google.com...
> What are the default privileges granted to public from users sys and
> system, and what privileges does public really need ?
> I am trying to create a user with a minimum of rights and privileges,
> and want to know what minimum specific grants and privileges from sys
> and system I can get by with.
> Thanks,
> Mark
Received on Mon Oct 21 2002 - 12:36:51 CDT