一.Oracle表明细及说明 1.dba_开头表 dba_users 数据库用户信息 dba_segments 表段信息 dba_extents 数据区信息 dba_objects 数据库对象信息 dba_tablespaces 数据库表空间信息 dba_data_files 数据文件设置信息 db
grantolap_dbatoDBA; grantscheduler_admintoDBAwithadminoption; grantselect_catalog_roletoDBAwithadminoption; grantwm_admin_roletoDBA; grantxdbadmintoDBA; --Grant/Revoke system privileges grantadministeranysql tuningsettoDBAwithadminoption; grantadministerdatabasetriggertoDBAwithadminoption; grantadminister ...
trace - Enable the tracing at the listener level. The available options are ‘trace OFF’, ‘trace USER’, ‘trace ADMIN’ or ‘trace SUPPORT’ spawn - Spawns a new with the program with the spawn_alias mentioned in the listener.ora file change_password - Set the new password to the o...
GRANT sys_priv_list TOuser_list|role_list|PUBLIC [WITH ADMIN OPTION]; 参数说明: sys_priv_list:表示系统权限列表,以逗号分隔; user_list:表示用户列表,以逗号分隔; role_list:表示角色列表,以逗号分隔; PUBLIC:表示对系统中所有用户授权; WITH ADMIN OPTION:表示允许系统权限接收者再把此权限授予其他用户。
用户应有权创建SELECT_CATALOG_ROLE分配的会话和角色。 或者,用户可以授予此连接器从中查询元数据的每个单独的系统表的 SELECT 权限: SQL grantcreatesessionto[user];grantselectonall_usersto[user];grantselectondba_objectsto[user];grantselectondba_tab_commentsto[user];grantselectondba_external_locationsto[us...
1、.:.;Oracle 常用系统表dba_ 开头dba_users数据库用户信息dba_segments表段信息dba_objects数据库对象信息dba_extents数据区信息dba_tablespaces 数据库表空间信息dba_data_files 数据文件设置信息dba_temp_files 暂时数据文件信息dba_rollback_segs 回滚段信息dba_ts_quotas 用户表空间配额信息dba_free_space 数据...
For a list of objects that can be replicated from an Oracle database, see Design Considerations and Limitations for Oracle Publishers. Note You must be a member of the sysadmin fixed server role to enable a Publisher or Distributor and to create an Oracle publication or a subscription from an...
ALTER USER xiaoli DEFAULTROLE defaultrole; (5)注册过程 CONNECT xiaoli/xiaoli@oracle 此时用户只有其缺省角色的权限。 (6)激活角色 SET ROLE checkerrole IDENTIFIEDBY xm361001; ---操作成功后,xiaoli拥有checkerrole的权限。 ---这里的角色和口令是固定的,在应用系统中可以由应用管理人员自行设置则更为方便安全...
DBA_PROFILES Displays all profiles and their limits DBA_TS_QUOTAS Describes tablespace quotas for users DBA_OBJECTS Describes all objects in the database DBA_USERS Describes all users of the database DBA_USERS_WITH_DEFPWD Lists all user accounts that have default passwords PROXY_USERS Des...
In the Agent Bakery you also have the option of creating standard users and creating exceptions for specific instances. The options, separated in the configuration file with a colon (for Linux & Co.) or as list entries (for Windows), you will find under Login Defaults as individual options ...