What are the Privileges granted to CTXAPP Role in Oracle Database 12c

Channel:

java frm

Subscribers:

5,740

Published on February 15, 2024 6:54:23 AM ● Video Link: https://www.youtube.com/watch?v=utg5q1-R1ME

Duration: 1:23

1 views

0

CTXAPP Provides privileges to create Oracle Text indexes and index preferences,
and to use PL/SQL packages. This role should be granted to Oracle Text
users.

This predefined role, is automatically defined for Oracle
databases when you run the standard scripts (such as catalog.sql and catproc.sql)
that are part of database creation, and they are considered common roles. If you
install other options or products, then other predefined roles may be created.

#oracledatabase #oracledatabase12c #oracle12c #12c #oracledba #oracletutorial #oracle #oracleroles #oraclepriviliges