Use PRODUCT_USER_PROFILE To Limit User，productprofile
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: http://docs.oracle.com/cd/A64702_01/doc/server.805/a53717/ape.htm
只使用于mysql的分页,SqlServer一般是用top来分页，oracle是用Rownum来进行分页
select * from table limit m,n
其中m是指记录开始的index，从0开始，表示第一条记录
n是指从第m+1条开始，取n条。
楼上大哥冒失这句有问题：
select * from tablename limit 10,20 --这语句是获取从第11条开始，取20条 应该是 11~30条
从第11条到31条（共计21条 吧）O(∩_∩)O哈哈~
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。