Shulou(Shulou.com)05/31 Report--

This article is to share with you about how oracle DBA implements character reconstruction. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Due to misoperation, the DBA role in the company's test database server was deleted directly in pl/sql developer, resulting in the loss of the permissions of system users to establish ordinary users, so they had to assist in their reconstruction. By viewing the information at night, the process is as follows:

-- Create the role

Create role DBA

-- Grant/Revoke object privileges

Grantexecuteon DBMS_DBVERIFY to DBA

Grantexecuteon DBMS_DEFER_QUERY to DBA

Grantexecuteon DBMS_DEFER_SYS to DBA

Grantexecuteon DBMS_FEATURE_USAGE to DBA

Grantexecuteon DBMS_FLASHBACK to DBA

Grantexecuteon DBMS_MONITOR to DBA

Grantexecuteon DBMS_RESUMABLE to DBA

Grantexecuteon DBMS_SERVER_ALERT to DBA

Grantexecuteon DBMS_SERVER_TRACE to DBA

Grantexecuteon DBMS_SERVICE to DBA

Grantexecuteon DBMS_STORAGE_MAP to DBA

Grantexecuteon DBMS_UADV_ARR to DBA

Grantexecuteon DBMS_UNDO_ADV to DBA

Grantexecuteon DBMS_WORKLOAD_REPOSITORY to DBA

Grantexecuteon LOAD_UNDO_STAT to DBA

Grantselect, insert, update, delete, alteron MAP_OBJECT to DBA

Grantexecuteon OUTLN_EDIT_PKG to DBA

Grantexecuteon OUTLN_PKG to DBA

Grantexecuteon RESET_UNDO_STAT to DBA

-- Grant/Revoke role privileges

Grant delete_catalog_role to DBA with admin option

Grant execute_catalog_role to DBA with admin option

Grant exp_full_database to DBA

Grant gather_system_statistics to DBA

Grant imp_full_database to DBA

Grant java_admin to DBA

Grant java_deploy to DBA

Grant olap_dba to DBA

Grant scheduler_admin to DBA with admin option

Grant select_catalog_role to DBA with admin option

Grant wm_admin_role to DBA

Grant xdbadmin to DBA

-- Grant/Revoke system privileges

Grant administer any sql tuning setto DBA with admin option

Grant administer databasetriggerto DBA with admin option

Grant administer resource manager to DBA with admin option

Grant administer sql tuning setto DBA with admin option

Grant advisor to DBA with admin option

Grantalterany cluster to DBA with admin option

Grantalterany dimension to DBA with admin option

Grantalterany evaluation context to DBA with admin option

Grantalteranyindexto DBA with admin option

Grantalterany indextype to DBA with admin option

Grantalterany library to DBA with admin option

Grantalterany materialized viewto DBA with admin option

Grantalterany outline to DBA with admin option

Grantalteranyprocedureto DBA with admin option

Grantalterany role to DBA with admin option

Grantalteranyruleto DBA with admin option

Grantalteranyrulesetto DBA with admin option

Grantalterany sequence to DBA with admin option

Grantalterany sql profile to DBA with admin option

Grantalteranytableto DBA with admin option

Grantalteranytriggerto DBA with admin option

Grantalterany type to DBA with admin option

Grantalterdatabaseto DBA with admin option

Grantalter profile to DBA with admin option

Grantalter resource cost to DBA with admin option

Grantalterrollback segment to DBA with admin option

Grantalter session to DBA with admin option

Grantalter system to DBA with admin option

Grantalter tablespace to DBA with admin option

Grantalteruserto DBA with admin option

Grant analyze anyto DBA with admin option

Grant analyze any dictionary to DBA with admin option

Grant audit anyto DBA with admin option

Grant audit system to DBA with admin option

Grantbackupanytableto DBA with admin option

Grant become userto DBA with admin option

Grant comment anytableto DBA with admin option

Grantcreateany cluster to DBA with admin option

Grantcreateany context to DBA with admin option

Grantcreateany dimension to DBA with admin option

Grantcreateany directory to DBA with admin option

Grantcreateany evaluation context to DBA with admin option

Grantcreateanyindexto DBA with admin option

Grantcreateany indextype to DBA with admin option

Grantcreateany job to DBA with admin option

Grantcreateany library to DBA with admin option

Grantcreateany materialized viewto DBA with admin option

Grantcreateany operator to DBA with admin option

Grantcreateany outline to DBA with admin option

Grantcreateanyprocedureto DBA with admin option

Grantcreateanyruleto DBA with admin option

Grantcreateanyrulesetto DBA with admin option

Grantcreateany sequence to DBA with admin option

Grantcreateany sql profile to DBA with admin option

Grantcreateany synonym to DBA with admin option

Grantcreateanytableto DBA with admin option

Grantcreateanytriggerto DBA with admin option

Grantcreateany type to DBA with admin option

Grantcreateanyviewto DBA with admin option

Grantcreate cluster to DBA with admin option

Grantcreatedatabase link to DBA with admin option

Grantcreate dimension to DBA with admin option

Grantcreate evaluation context to DBA with admin option

Grantcreate indextype to DBA with admin option

Grantcreate job to DBA with admin option

Grantcreate library to DBA with admin option

Grantcreate materialized viewto DBA with admin option

Grantcreate operator to DBA with admin option

Grantcreateprocedureto DBA with admin option

Grantcreate profile to DBA with admin option

Grantcreatepublicdatabase link to DBA with admin option

Grantcreatepublic synonym to DBA with admin option

Grantcreate role to DBA with admin option

Grantcreaterollback segment to DBA with admin option

Grantcreateruleto DBA with admin option

Grantcreaterulesetto DBA with admin option

Grantcreate sequence to DBA with admin option

Grantcreate session to DBA with admin option

Grantcreate synonym to DBA with admin option

Grantcreatetableto DBA with admin option

Grantcreate tablespace to DBA with admin option

Grantcreatetriggerto DBA with admin option

Grantcreate type to DBA with admin option

Grantcreateuserto DBA with admin option

Grantcreateviewto DBA with admin option

Grant debug anyprocedureto DBA with admin option

Grant debug connect session to DBA with admin option

Grantdeleteanytableto DBA with admin option

Grant dequeue any queue to DBA with admin option

Grantdropany cluster to DBA with admin option

Thank you for reading! This is the end of the article on "how to reconstruct the role of oracle DBA". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.