1 PACKAGE XS_ROLESET AUTHID CURRENT_USER AS
2
3 -- Enable log based replication for this package
4 PRAGMA SUPPLEMENTAL_LOG_DATA(default, AUTO);
5
6 -- Roleset creation API
7 PROCEDURE create_roleset (
8 name IN VARCHAR2,
9 role_list IN XS$NAME_LIST:=NULL,
10 description IN VARCHAR2:=NULL);
11
12 -- Add a role to the role set
13 PROCEDURE add_roles (
14 role_set IN VARCHAR2,
15 role IN VARCHAR2);
16
17 -- Add a list of roles to the role set
18 PROCEDURE add_roles (
19 role_set IN VARCHAR2,
20 role_list IN XS$NAME_LIST);
21
22 -- Remove all roles from the role set
23 PROCEDURE remove_roles (
24 role_set IN VARCHAR2);
25
26 -- Remove a role from the role set
27 PROCEDURE remove_roles (
28 role_set IN VARCHAR2,
29 role IN VARCHAR2);
30
31 -- Remove a list of roles from the role set
32 PROCEDURE remove_roles (
33 role_set IN VARCHAR2,
34 role_list IN XS$NAME_LIST);
35
36 -- Set the description of a roleset
37 PROCEDURE set_description (
38 role_set IN VARCHAR2,
39 description IN VARCHAR2);
40
41 -- Delete the role set. A roleset is not referenced anywhere. So no delete
42 -- option is needed.
43 PROCEDURE delete_roleset (
44 role_set IN VARCHAR2);
45
46
47 END XS_ROLESET;