Re: database privileges

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 21 Oct 2002 19:20:39 +0200
Message-ID: <hpd8ru01ud41e5koo47q0r6bk0c5f329c5@4ax.com>

On 21 Oct 2002 09:39:05 -0700, oil1can_at_yahoo.com (mark) wrote:

>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

select * from dba_tab_privs where grantee = 'PUBLIC' and
select * from dba_sys_privs where grantee = 'PUBLIC'

should give you the results.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Oct 21 2002 - 12:20:39 CDT