作者：紫逸石 | 来源：互联网 | 2014-08-26 16:07
ThePRODUCT_USER_PROFILE(PUP)tableprovidesproduct-levelsecuritythatsupplementstheuser-levelsecurityprovidedbytheSQLGRANTandREVOKEcommandsand
The PRODUCT_USER_PROFILE
(PUP) table provides product-level security that supplements the user-level security provided by the SQL GRANT and REVOKE commands and user roles. To create the PUP table, log in to SQL*Plus as the SYSTEM user and run PUPBLD.SQL which is located in the ORACLE_HOME\SQLPLUS\ADMIN
directory with:
[oracle@nbuserver admin]$ ls
glogin.sql help libsqlplus.def plustrce.sql pupbld.sql
[oracle@nbuserver admin]$
[oracle@nbuserver admin]$
[oracle@nbuserver admin]$
[oracle@nbuserver admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Aug 24 07:20:41 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@orcl11g>@pupbld.sql
insert into product_user_profile values('SQL*Plus','SCOTT','DROP',null,null,'DISABLED',null,null);
reconnect sql*plus:
conn scott/tiger;
Connected.
SYS@orcl11g>conn scott/tiger;
Connected.
SCOTT@orcl11g>drop table zbdba;
SP2-0544: Command "drop" disabled in Product User Profile
for more information:
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有 