Oracle | XS_ROLESET

Oracle XS_ROLESET Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Real Application Security Role Set Management

AUTHID CURRENT_USER

Data Types SYS.XS$NAME_LIST VARRAY(1000) OF VARCHAR2(261)

Dependencies

PLITBLM	XS_ADMIN_INT	XS_ROLESET_INT
XS$NAME_LIST	XS_ADMIN_UTIL

Documented No

First Available 2009

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, AUTO);

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/

Subprograms

ADD_ROLES	DELETE_ROLESET	SET_DESCRIPTION
CREATE_ROLESET	REMOVE_ROLES

ADD_ROLES

Adds a role to a role set

Overload 1 xs_roleset.add_roles( role_set IN VARCHAR2, role IN VARCHAR2);

exec xs_roleset.add_roles('UW_RAS_ROLESET', 'XS_CACHE_ADMIN');

      

      PL/SQL procedure successfully completed

Overload 2 xs_roleset.add_roles( role_set IN VARCHAR2, role_list IN XS$NAME_LIST);

DECLARE

       nList sys.xs$name_list;

      BEGIN

        nList := sys.xs$name_list('');

        nList(1) := 'XS_CONNECT';

        nList.extend;

        nList(2) := 'XS_SESSION_ADMIN';

        xs_roleset.add_roles('UW_RAS_ROLESET', nList);

      END;

      /

      

      PL/SQL procedure successfully completed.

CREATE_ROLESET

Roleset creation API xs_roleset.create_roleset( name IN VARCHAR2, role_list IN XS$NAME_LIST := NULL, description IN VARCHAR2 := NULL);

exec xs_roleset.create_roleset('UW_RAS_ROLESET');

      

      PL/SQL procedure successfully completed

DELETE_ROLESET

Delete a role set xs_roleset.delete_roleset(role_set IN VARCHAR2);

exec xs_roleset.delete_roleset('UW_RAS_ROLESET');

      

      PL/SQL procedure successfully completed

REMOVE_ROLES

Remove all roles from a role set

Overload 1 xs_roleset.remove_roles(role_set IN VARCHAR2);

exec xs_roleset.remove_roles('UW_RAS_ROLESET');

      

      PL/SQL procedure successfully completed

Remove a single role from the role set

Overload 2 xs_roleset.remove_roles( role_set IN VARCHAR2, role IN VARCHAR2);

exec xs_roleset.remove_roles('UW_RAS_ROLESET', 'XS_CACHE_ADMIN');

      

      PL/SQL procedure successfully completed

Remove a list of roles from the role set

Overload 3 xs_roleset.remove_roles( role_set IN VARCHAR2, role_list IN XS$NAME_LIST);

DECLARE

       nList sys.xs$name_list;

      BEGIN

        nList := sys.xs$name_list('');

        nList(1) := 'XS_CONNECT';

        nList.extend;

        nList(2) := 'XS_SESSION_ADMIN';

        
      xs_roleset.remove_roles('UW_RAS_ROLESET', nList);

      END;

      /

      

      PL/SQL procedure successfully completed.

SET_DESCRIPTION

Set roleset's description xs_roleset.set_description( role_set IN VARCHAR2, description IN VARCHAR2);

exec xs_roleset.set_description('UW_RAS_ROLESET', 'RAS Roleset');

      

      PL/SQL procedure successfully completed.

      

      SELECT * FROM XS$ROLESET_ROLES;

      

           RSID#      ROLE#

      ---------- ----------

      2147493729 2147493730

      

      col ctime format a30

      col mtime format a30

      col description format a30

      

      SELECT * FROM xs$roleset;

      

           RSID# CTIME                        MTIME                        DESCRIPTION

      ---------- ---------------------------- ---------------------------- -----------

      2147493729 29-APR-24 02.49.32.643930 AM 29-APR-24 03.05.36.818089 AM RAS Roleset

Morgan's Library Page Footer

This site is maintained by Daniel Morgan. Last Updated: