Home » RDBMS Server » Security » REVOKE [privilege] ON [owner].[object] FROM PUBLIC
REVOKE [privilege] ON [owner].[object] FROM PUBLIC [message #173775] Wed, 24 May 2006 07:05 Go to next message
kirdha1
Messages: 18
Registered: July 2005
Junior Member
WE have the report from the auditor to revoke some of the REVOKE [privilege] ON [owner].[object] FROM PUBLIC

such as

(Owner=SYS) (Object Name=DUAL) (Privilege=SELECT)
(Owner=SYS) (Object Name=SYSTEM_PRIVILEGE_MAP) (Privilege=SELECT)
(Owner=SYS) (Object Name=TABLE_PRIVILEGE_MAP) (Privilege=SELECT)
(Owner=SYS) (Object Name=STMT_AUDIT_OPTION_MAP) (Privilege=SELECT)
(Owner=SYS) (Object Name=STANDARD) (Privilege=EXECUTE)
(Owner=SYS) (Object Name=DBMS_STANDARD) (Privilege=EXECUTE)
(Owner=SYS) (Object Name=USER_REGISTRY) (Privilege=SELECT)
(Owner=SYS) (Object Name=ALL_REGISTRY_BANNERS) (Privilege=SELECT)
(Owner=SYS) (Object Name=V_$BH) (Privilege=SELECT)
(Owner=SYS) (Object Name=V_$SESSION_LONGOPS) (Privilege=SELECT)
(Owner=SYS) (Object Name=V_$NLS_PARAMETERS) (Privilege=SELECT)

and many others


I would like to know how safe is it to revoke such privilege from the public role.

Pl. help..


Re: REVOKE [privilege] ON [owner].[object] FROM PUBLIC [message #174327 is a reply to message #173775] Sat, 27 May 2006 15:00 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Privileges granted to PUBLIC mean that anyone can use them. If you revoke any of it, you can expect that some of them will have to be granted explicitly to users when necessary.
Previous Topic: Username/Password for SQLPlus3.3
Next Topic: User-specific trigger auditing
Goto Forum:
  


Current Time: Thu Mar 28 21:30:47 CDT 2024