newlangwen

摘要： 查询用户和权限select object_name,createdfrom user_objects;受权grant select any table,create table,create view to dbjcy;查询表空间select tablespace_name from dba_tablespaces;查询用户的权限select *from session_privs;收回用户权限revoke select any table,create table,create view,create sessionfrom dbjcy;revoke selecton cat.baby.ca 阅读全文

摘要： select * from user_constraintswhere table_name='';select * from user_cons_columns; 阅读全文