Database user Rights

ALTER any PROCEDURE

CREATE any PROCEDURE

CREATE PROCEDURE

DEBUG any PROCEDURE

DROP any PROCEDURE

EXECUTE any PROCEDURE

To grant debug permissions to a stored procedure to a user, you can only grant the user permission to view the stored procedure definition, and restrict the user from modifying and executing the stored procedure. This allows only authorized users to view the stored procedure definition permissions.

--View the role permissions that the current session user has;

SELECT * from Session_roles;

--View the system permissions that the current user has, including what is attached to the role permissions. ）

SELECT * from Session_privs;

--Remove permissions

Revoke DEBUG any PROCEDURE from search;

--Delete database user

DROP USER SEARCH CASCADE;

Create a database user

CREATE USER search identified by SEARCH;

GRANT CONNECT to SEARCH;

GRANT SELECT any TABLE to SEARCH;

--1, querying user session information:

Select username, sid, serial#, machine from v$session WHERE username= ' SEARCH ';

--Delete User session information:

Alter system kill session ' Sid, Serial# ';

CREATE SESSION

CREATE TABLE

SELECT any TABLE

UPDATE any TABLE

CREATE CLUSTER

CREATE SEQUENCE

SELECT any SEQUENCE

CREATE PROCEDURE

CREATE any PROCEDURE

CREATE TRIGGER

CREATE TYPE

CREATE OPERATOR

CREATE Indextype

DEBUG any PROCEDURE

EXECUTE any TYPE

ALTER any PROCEDURE

--Remove the DBA role of the search user

Revoke DBA from Search

Database user Rights