Use PRODUCT_USER_PROFILE To Limit User
2024-09-12 07:26:46
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
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
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
SYS@orcl11g>conn scott/tiger;
Connected.
SCOTT@orcl11g>drop table zbdba;
SP2-0544: Command "drop" disabled in Product User Profile
for more information:
版权声明:本文博主原创文章。博客,未经同意不得转载。
最新文章
- JavaScript对象篇之hasOwnProperty
- osgEarth编译的一些问题
- tq2440开发板基本配置
- 关于C#中Thread.Join()的一点理解
- struts2在result中使用el表达式碰到的问题
- C# 一个WCF简单实例
- (转)centos7安装telnet服务
- Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field
- [物理学与PDEs]第1章第6节 电磁场的标势与矢势 6.2 电磁场的标势与矢势
- 20175213《Java程序设计》实验二Java面向对象程序设计实验报告
- JS分页条插件
- Java中的ASCII码与Unicode码
- uva-11129-分治
- BZOJ 4361 isn | DP 树状数组
- jenkins自动构建部署
- Install Identity management Database
- VC++获取操作系统的版本 GetVersionEx函数
- JAVA中的static方法
- Ubuntu安装Nginx和正确卸载Nginx Nginx相关
- JS 快速获取数据中的最大、最小值
热门文章
- Android 混淆proguard的实现(图文)
- [LeetCode]Word Ladder 最短距离字符串转换 (Dijkstra)
- Hadoop-2.2.0中文文档—— MapReduce下一代- 可插入的 Shuffle 和 Sort
- JAVA编程思想(2) - 操作符(一)
- 制作service服务,shell脚本小例子(来自网络)
- Paint获取Text的宽和高的数据
- Error Code: 1318. Incorrect number of arguments for PROCEDURE company.new_procedure; expected 2, got
- isset,empty,is_null小知识
- MapReduce源代码分析MapTask分析
- oracle设备