Oracle | XS_ROLESET

Oracle XS_ROLESET_INT 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 DEFINER

Dependencies

PLITBLM	XS$ROLESET_ROLES	XS_ADMIN_UTIL
XS$NAME_LIST	XS_ADMIN_INT	XS_ROLESET
XS$ROLESET

Documented No

First Available 2009

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtxsrs.plb

Subprograms

ADD_ROLES	DELETE_ROLESET	SET_DESCRIPTION
CREATE_ROLESET	REMOVE_ROLES

ADD_ROLES

Adds a role to a role set

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

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

      

      PL/SQL procedure successfully completed

Overload 2 xs_roleset_int.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_int.add_roles('UW_RAS_ROLESET', nList);

      END;

      /

      

      PL/SQL procedure successfully completed.

CREATE_ROLESET

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

exec xs_roleset_int.create_roleset('UW_RAS_ROLESET');

      

      PL/SQL procedure successfully completed

DELETE_ROLESET

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

exec xs_roleset_int.delete_roleset('UW_RAS_ROLESET');

      

      PL/SQL procedure successfully completed

REMOVE_ROLES

Remove all roles from a role set

Overload 1 xs_roleset_int.remove_roles(role_set IN VARCHAR2);

exec xs_roleset_int.remove_roles('UW_RAS_ROLESET');

      

      PL/SQL procedure successfully completed

Remove a single role from the role set

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

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

Remove a list of roles from the role set

Overload 3 xs_roleset_int.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_int.remove_roles('UW_RAS_ROLESET', nList);

      END;

      /

      

      PL/SQL procedure successfully completed.

SET_DESCRIPTION

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

exec xs_roleset_int.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: