oracle grant all privileges to user

First to create a AA user: sys@orcl> create user AA identified by AA; User created. To view user rights with an HR user login: Sys@orcl> Conn Hr/hr Connected. Hr@orcl> select * from Session_privs; Privilege ---------------------------------------- CREATE session AL

1, if there is a Plsql client, you can use the user login, select all the table right-click Drop.2. If you have permission to delete a user, you can:[SQL]View Plaincopy Drop user user_name cascade; Add the cascade can delete the user data.Delete and then creat

First, login issues1, forget the user name password:(1) Default User name password:System/manager Sys/change_on_install Scott/tiger(2) CMD log in as a system administrator:C:\users\samsung>sqlplus System/manager as SysdbaView all User:Sql> select username from dba_users;To modify a user password:Sql> alter

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 Admin user user name identified by password default tablespace spac

Tags: Oracle user Information role1. 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 Us

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 names and

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

The following statements are used to query all your tables in Oracle. If you are interested in oracle queries, take a look. Select * fromall_tab_commen The following statements are used to query all your tables in Oracle. If you are interested in

Label: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 t

c.table_name = table to queryQuery the column name of the FOREIGN KEY constraint:SELECT * from 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

1, if there is a Plsql client, you can use the user login, select all the table right key drop can be.2, if you have the right to delete users, you can: Drop user user_name cascade; Cascade can be added to the users of all the data deleted. Delete and then create the user