内容摘要
失效链接处理 Oracle DBA commands real world experience PDF 下载 下载地址: 链接: https://pan.baidu.com/s/12bxwQmK5sVwk8nwIjYY1NQ 提取码: a8of 相关截图: 主要内容: Oracle DBA Commands from Real World Experience Command Auth ID Function SELECT owner, table_name, tablespace_name FROM dba_tables where owner = 'TST' AND table_name = 'EXAMPLE1'; SYSDBA Check table’s current tablespace SELECT username, default_tablespace FROM dba_users WHERE username = 'TST'; SYSDBA Check user’s default tablespace SELECT * FROM database_properties WHERE property_name = 'DEFAULT_PERMANENT_TABLESPACE'; SYSDBA Check default tablespace if doesn’t specify a tablespace SELECT * FROM DBA_SYS_PRIVS ORDER BY 1; SYSDBA Check granted SYS privileges SELECT * FROM DBA_TAB_PRIVS; SYSDBA Check granted OBJECT privileges • CREATE USER john IDENTIFIED BY john1234; • CREATE USER john IDENTIFIED BY john1234
本站为你提供的『Oracle DBA commands real world experience PDF 下载』为【百度云搜搜】搜索整理的结果,信息来源于第三方网站,本站只提供检索服务,不存储任何资源。本页面由蜘蛛程序自动抓取生成,如有侵权违规,可点击下方联系我们举报,我们立即删除。