Re: A Query about GRANT ALL PRIVILEGES in ORACLE
From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Wed, 4 Feb 2004 12:48:09 +0000
Message-ID: <BAswIjAJoOIARxyT_at_peterfinnigan.demon.co.uk>
Date: Wed, 4 Feb 2004 12:48:09 +0000
Message-ID: <BAswIjAJoOIARxyT_at_peterfinnigan.demon.co.uk>
Hi,
Try this;
---------- ------------------------------ 2 EMIL 139 MDSYS 139 ZULIA
SQL> We used MDSYS as a checkpoint as MDSYS has all privileges granted to it by default in a default installation of Oracle. The privilege you need therefore is GRANT ANY PRIVILEGE.
I should ask WHY?, it is not a good idea to grant all privileges to any user in the database. Just grant the privileges that are needed by your user. Use the least privilege principle.
hth
kind regards
Pete
-- Pete Finnigan email:pete_at_petefinnigan.com Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details.Received on Wed Feb 04 2004 - 13:48:09 CET