Use product_user_profile to limit user

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:

[[Email protected] admin] $ ls
Glogin. SQL help libsqlplus. Def plustrce. SQL pupbld. SQL
[[Email protected] admin] $
[[Email protected] admin] $
[[Email protected] admin] $
[[Email protected] 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

[Email protected]> @ pupbld. SQL

Insert into product_user_profile values ('SQL * Plus', 'Scott ', 'drop', null, null, 'Disabled', null, null); reconnect SQL * Plus: conn Scott/tiger; connected.
[Email protected]> conn Scott/tiger;
Connected.
[Email protected]> 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

Use product_user_profile to limit user