08 2020 档案
摘要:SELECT OBJECT_NAME(ii.id) TableName ,rows FROM sysindexes ii INNER JOIN sysobjects oo ON ( oo.id = ii.id AND oo.xtype = 'U ') WHERE ii.indid < 2 ORDER
阅读全文
摘要:一、查看用户及权限 1.查询所有用户: 1.1、查看所有用户基本信息 select * from all_users; 1.2、查看所有用户相信信息 select * from dba_users; 2.查看用户权限 2.1 查看所有用户 SELECT * FROM DBA_USERS; SELEC
阅读全文