Insufficient previliges In Oracle.

Insufficient previliges In Oracle.

Following is the list of all the previliges this user has.

PRIVILEGE

CREATE ANY SQL PROFILE

DROP ANY SQL PROFILE

GRANT ANY OBJECT PRIVILEGE

DEBUG CONNECT SESSION

RESUMABLE

ADMINISTER DATABASE TRIGGER

ADMINISTER RESOURCE MANAGER

DROP ANY OUTLINE

DROP ANY CONTEXT

CREATE ANY CONTEXT

MANAGE ANY QUEUE

DROP ANY DIMENSION

CREATE ANY DIMENSION

GLOBAL QUERY REWRITE

DROP ANY INDEXTYPE

CREATE ANY INDEXTYPE

DROP ANY OPERATOR

CREATE ANY OPERATOR

DROP ANY LIBRARY

CREATE ANY LIBRARY

EXECUTE ANY TYPE

DROP ANY TYPE

ALTER ANY TYPE

CREATE ANY TYPE

DROP ANY DIRECTORY

CREATE ANY DIRECTORY

DROP ANY MATERIALIZED VIEW

ALTER ANY MATERIALIZED VIEW

CREATE ANY MATERIALIZED VIEW

ANALYZE ANY

DROP PROFILE

CREATE PROFILE

DROP ANY TRIGGER

ALTER ANY TRIGGER

CREATE ANY TRIGGER

EXECUTE ANY PROCEDURE

DROP ANY PROCEDURE

ALTER ANY PROCEDURE

CREATE ANY PROCEDURE

CREATE PROCEDURE

AUDIT ANY

DROP ANY ROLE

CREATE ROLE

DROP PUBLIC DATABASE LINK

CREATE PUBLIC DATABASE LINK

CREATE DATABASE LINK

DROP ANY SEQUENCE

CREATE ANY SEQUENCE

DROP ANY VIEW

CREATE ANY VIEW

DROP PUBLIC SYNONYM

CREATE PUBLIC SYNONYM

DROP ANY SYNONYM

CREATE ANY SYNONYM

DROP ANY INDEX

ALTER ANY INDEX

CREATE ANY INDEX

DROP ANY CLUSTER

CREATE ANY CLUSTER

DELETE ANY TABLE

UPDATE ANY TABLE

INSERT ANY TABLE

SELECT ANY TABLE

COMMENT ANY TABLE

DROP ANY TABLE

ALTER ANY TABLE

CREATE ANY TABLE

DROP ROLLBACK SEGMENT

CREATE ROLLBACK SEGMENT

DROP USER

BECOME USER

CREATE USER

UNLIMITED TABLESPACE

DROP TABLESPACE

ALTER TABLESPACE

CREATE TABLESPACE

CREATE SESSION

ALTER SYSTEM



How to grant previliges to user On Procedure


GRANT EXECUTE ON PROCEDURE TEST_PRO TO Hr;


How to grant previliges to user On Views


grant create any view to grsadm

Read More