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:
[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,201 3, Oracle. All rights reserved.
Connected:
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
Select * from user limit 0, 10;
It is only used for mysql paging. SqlServer generally uses top for paging, while oracle uses Rownum for paging.
Select * from user imit 1, 3; meaning of limit 1, 3
Select * from table limit m, n
M indicates the index at the beginning of the record. Starting from 0, it indicates the first record.
N refers to n records starting from the m + 1.
Brother upstairs has the following question:
Select * from tablename limit 10, 20 -- this statement is used to obtain the first 11th records, and the 20 records should be 11 ~ 30
From 11th to 31 (21 in total) O (∩ _ ∩) O Haha ~