oracle grant all privileges to user

[Email protected] ~]# su-oracle[Email protected] ~]$ Sqlplus/nologSql*plus:release 10.2.0.1.0-production on Tue Jul 8 21:47:01 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Sql> Conn/as sysdba;Connected.Querying all user information in Oracle1. View

User_cons_columns cl where cl.constraint_name = FOREIGN key NameQuery the column name of the key referencing the table:SELECT * from User_cons_columns cl where cl.constraint_name = foreign key reference table key name5. Querying all columns of the table and their propertiesSelect t.*,c.comments from User_tab_columns t,user_col_comments c where t.table_name = C.table_name and T.column_name = c. column_name and t.table_name = table to query6. Table nam

Dba_sys_privs where grantee= ' TOM '; 9. How Oracle Deletes all tables for the specified userSelect ' Drop table ' | | table_name| | '; ' from All_tablesWhere owner= ' user name to delete (note to capitalize) '; 10. Delete UsersDrop user user_name cascade;such as: Drop user

1. View All Users:SELECT * from Dba_users;SELECT * from All_users;SELECT * from User_users;2. View user or role system permissions (System permissions that are directly assigned to a user or role):SELECT * from Dba_sys_privs;SELECT * from User_sys_privs; (View the permissions that the current user has)3. View the permi

All about Oracle User-Managed Database Backups The V $ BACKUP view is most useful when the database is open. it is also useful immediately after an instance failure because it shows the backup status of the files at the time of the failure. use this information to determine whether you have left any tablespaces in backup mode. V $ BACKUP is not useful if the cont

' Exp username/[email protected] tables= ' | | table_name| | ' File= ' | | table_name| | '. DMP Triggers=n ' from User_tables; Spool off; Set feedback on; Set pagesize 9999; Set heading on; Set verify on; When exit is complete, the. bat file is found in the C: \ database, the batch file is edited, the first and last lines are deleted, and all the tables under that user are exported after saving the batch f

Oracle: View All Tables and table columns of the current user, including yellowcong and oracleyellowcong. I have previously written a tool to dynamically generate the oracle entity class function, but this tool can only be used for the Searsar project. Therefore, it is of little significance, but it can also be extend

The following statements are used to query all your tables in Oracle. If you are interested in Oracle queries, take a look. Select * From all_tab_comments -- query tables and views of all users Select * From user_tab_comments -- query the user's tables and views Select * From all_col_comments -- Query the column na

Export the table structures of all user tables in the Oracle database and store them in an Excel table. The storage information is shown in: Export the table structures of all user tables in the Oracle database and store them in a

1. Disable all foreign key constraints Run the following statement in PL/SQL developer: Select 'alter table' | table_name | 'Disable constraint' | constraint_name | ';' from user_constraints where constraint_type = 'R '; Copy the query results to be executed in PL/SQL developer. If PL/SQL developer is not available, perform the following operations in sqlplus: 1. Open sqlplus and connect with the corresponding

Delete the object oracle --. SQL script-the only note is the following f: dropobj. SQL is the operation. SQL; -- your computer does not have a drive F, please replace it with D or E another drive letter -- used to delete all objects of the current user -- usefordropallobjectsincurrentuser; setheadingoff; setfeedback Delete the object

The following articles mainly describe how to export all tables of certain users in Oracle databases. In actual applications, many users may use Oracle, related customers generally want to export all tables of related users. This article provides such a method to help you solve this problem easily. First, log on to the

-- Delete package033Select 'drop package' | object_name | ';' | chr (13) | chr (10) from user_objects where object_type = 'package ';034035-- Delete trigger036SELECT 'drop TRIGGER "'| SYS_CONTEXT ('userenv', 'current _ user') | '". "'| TRIGGER_NAME |'"; '| CHR (13) | CHR (10) FROM USER_TRIGGERS037038039Spool off;040@/Tmp/database/drop_tables. SQL;041042Purge recyclebin; -- clear the Oracle Recycle Bin043044

Oracle uses a cursor to create a primary key statement for all user tables Application Scenario: adding an auto-increment primary key to a data table can speed up data table access, and is the fastest in integer indexing. This program is suitable for running when the Oracle database is imported and the primary key does

To query all the user tables in Oracle, USER_TABLES sometimes needs to clean up, count, and analyze existing databases. This requires you to know how much data there are in the databases. in Oracle, you can use the view USER_TABLES: SELECT * FROM USER_TABLES; USER_TABLES provides a wealth of information, of which the m

How Does Oracle search for fields containing a certain value in all tables of the current user? CreateorreplaceprocedureMY_Pro_SearchKeyWordisv_sqlVARCHAR2 (40 How Does Oracle search for fields containing a certain value in all tables of the current

Many oracle users may want to export all the tables of a user. This article provides this method to help you easily solve this problem. First, log on to the Oracle database with this user under sqlplus, And Then paste the following content into sqlplus: Set feedback off;Se

... begin sql_str: = ' Select Uo.object_name,uo.object_type from User_objects uo where Uo.object_type not in ("INDEX", "LOB") Order by uo.object_type Desc '; EXECUTE IMMEDIATE sql_str BULK COLLECT into Tab_name,tab_type;For I in Tab_name. First: Tab_name. Last LOOP begin sql_str: = ' DROP ' | | Tab_type (i) | | "| | Tab_name (i); EXECUTE IMMEDIATE Sql_str; Dbms_output.put_line (SQL_STR);Exception when others then v_err_code: = SQLCODE; V_err_msg: = SUBSTR (SQLERRM, 1, 200); Dbms_output. Put

Label:1. If you have permission to delete a user, you can:Drop user user_name cascade;Add the cascade can delete the user data.Delete and then create the user.--Create an administrator userCreate user username identified by password default tablespace space_data (tablespace

During this time, a configuration library needs to be imported to different people. After each person is imported to the database, all the tables in the Database need to be cleared. If you want to import tables one by one, it is very troublesome, therefore, the following PLSQ During this time, a configuration library needs to be imported to different people. After each person is imported to the database, all