1 PACKAGE dbms_credential AUTHID CURRENT_USER AS
2
3 ---Allowed credential logging levels
4
5 /*************************************************************
6 * Credential Administration Procedures
7 *************************************************************
8 */
9
10 -- Create a new credential. The credential name can be optionally qualified
11 -- with a schema.
12 PROCEDURE create_credential(
13 credential_name IN VARCHAR2,
14 username IN VARCHAR2,
15 password IN VARCHAR2,
16 database_role IN VARCHAR2 DEFAULT NULL,
17 windows_domain IN VARCHAR2 DEFAULT NULL,
18 comments IN VARCHAR2 DEFAULT NULL,
19 enabled IN BOOLEAN DEFAULT TRUE);
20
21 -- Drops an existing credential (or a comma separated list of credentials).
22 -- When force is set to false the credential must not be
23 -- referred to by any job or extproc. When force is set to true,
24 -- any jobs referring to this credential will be disabled (same behavior
25 -- as calling the disable routine on those jobs with the force option).
26 -- exproc alias libraries that reference the credential will become invalid
27 PROCEDURE drop_credential(
28 credential_name IN VARCHAR2,
29 force IN BOOLEAN DEFAULT FALSE);
30
31 -- Update credential changes the value of an attribute for a given credential
32 -- credential attributes which can be updated with the following call:
33 --
34 -- username - VARCHAR2
35 -- user to execute the job as.
36 -- password - VARCHAR2
37 -- password to use to authenticate the user
38 -- comments - VARCHAR2
39 -- an optional comment. This can describe what the
40 -- credential is intended to be used for.
41 -- windows_domain - VARCHAR2
42 -- Windows domain to use when logging in
43 -- NOTE-------------------------
44 -- The ENABLED attribute can not be updated with this call
45 PROCEDURE update_credential(
46 credential_name IN VARCHAR2,
47 attribute IN VARCHAR2,
48 value IN VARCHAR2);
49
50 -- Disables an existing Oracle credential
51 -- If force is set to FALSE, the credential must not be referenced by any
52 -- object or library. If the credential is referenced by an object, the call
53 -- returns error
54 -- If force is set to TRUE, the credential will be disabled either way
55 PROCEDURE disable_credential(
56 credential_name IN VARCHAR2,
57 force IN BOOLEAN DEFAULT FALSE);
58
59 -- Enables an existing oracle credential
60 --This will NOT return an error if the credential was enabled already
61 PROCEDURE enable_credential(
62 credential_name IN VARCHAR2);
63
64 END dbms_credential;