使用PRODUCT_USER_PROFILE禁止特定用户在SQLPlus中使用delete语句
1.在sys用户下执行脚本pupbld.sql使PRODUCT_USER_PROFILE可用
pupbld.sql脚本所在目录为$ORACLE_HOME/sqlplus/admin/pupbld.sql
sys@ora10g> conn / as sysdba
Connected.
sys@ora10g> @?/sqlplus/admin/pupbld.sql
2.向product_user_profile中出入如下限制信息
sys@ora10g> insert into
product_user_profile(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE) values
('SQL*Plus','SEC','DELETE','DISABLED');
1 row created.
sys@ora10g> commit;
Commit complete.
sys@ora10g> col PRODUCT for
a10
sys@ora10g> col
USERID for a10
sys@ora10g> col ATTRIBUTE for a10
sys@ora10g> col CHAR_VALUE for a10
sys@ora10g> select
PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE from product_user_profile;
PRODUCT
USERID ATTRIBUTE CHAR_VALUE
---------- ---------- ---------- ----------
SQL*Plus
SEC DELETE
DISABLED
3.验证效果
sys@ora10g> conn sec/sec
Connected.
sec@ora10g> select * from t;
A
----------
1
1
1
1
1
sec@ora10g> delete from t;
SP2-0544: Command "delete" disabled in
Product User Profile
这种限制方法已经生效，从此，sec用户将不可以再执行删除delete操作。
OK，这个小实验到此先告一段落。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31448824/viewspace-2139365/ ，如需转载，请注明出处，否则将追究法律责任。
