Define the SQL Administrative Privilege mapping in the ^SYS global Mapping was added for SQL Privileges to take advantage of XML export Map Data Order: #; 1 - CREATE_FUNCTION #; 2 - DROP_FUNCTION #; 3 - CREATE_METHOD #; 4 - DROP_METHOD #; 5 - CREATE_PROCEDURE #; 6 - DROP_PROCEDURE #; 7 - CREATE_QUERY #; 8 - DROP_QUERY #; 9 - CREATE_TABLE #; 10 - ALTER_TABLE #; 11 - DROP_TABLE #; 12 - CREATE_VIEW #; 13 - ALTER_VIEW #; 14 - DROP_VIEW #; 15 - CREATE_TRIGGER #; 16 - DROP_TRIGGER #; 17 - NOCHECK #; 18 - NOTRIGGER #; 19 - NOINDEX #; 20 - NOLOCK #; 21 - BUILD_INDEX #; 22 - CREATE_ML_CONFIGURATION #; 23 - ALTER_ML_CONFIGURATION #; 24 - DROP_ML_CONFIGURATION #; 25 - MANAGE_MODEL #; 26 - USE_MODEL #; 27 - DROP_UNOWNED #; 28 - NOJOURN #; 29 - CANCEL_QUERY. More...

Inheritance diagram for SQLAdminPrivilegeSet:

[legend]

Collaboration diagram for SQLAdminPrivilegeSet:

[legend]

Static Public Member Functions
_.Library.Status	Export (_.Library.String FileName, _.Library.Integer NumExported)
	This method exports SQL Admin Privilege Set records to a file in xml format. More...

_.Library.Status	Import (_.Library.String FileName, _.Library.Integer NumImported, _.Library.Integer Flags)
	Import SQLAdminPrivilegeSet records from an xml file. More...

Public Attributes
	AlterMLConfiguration
	AlterMLConfiguration - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	AlterTable
	AlterTable - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	AlterView
	AlterView - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	BuildIndex
	BuildIndex - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	CancelQuery
	CancelQuery - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	CreateFunction
	CreateFunction - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	CreateMLConfiguration
	CreateMLConfiguration - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	CreateMethod
	CreateMethod - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	CreateProcedure
	CreateProcedure - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	CreateQuery
	CreateQuery - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	CreateTable
	CreateTable - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	CreateTrigger
	CreateTrigger - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	CreateView
	CreateView - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	DropFunction
	DropFunction - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	DropMLConfiguration
	DropMLConfiguration - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	DropMethod
	DropMethod - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	DropProcedure
	DropProcedure - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	DropQuery
	DropQuery - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	DropTable
	DropTable - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	DropTrigger
	DropTrigger - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	DropUnowned
	DropUnowned - 0/1/2, can this user is allowed to drop any sql object they are not the owner of 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	DropView
	DropView - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	Grantee
	Grantee - user/role the privilege was granted to. More...

	ManageModel
	ManageModel - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	Namespace
	Namespace the privilege is defined in. More...

	NoCheck
	NoCheck - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	NoIndex
	NoIndex - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	NoJourn
	NoJourn - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	NoLock
	NoLock - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	NoTrigger
	NoTrigger - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

	UseModel
	UseModel - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable. More...

Detailed Description

Define the SQL Administrative Privilege mapping in the ^SYS global Mapping was added for SQL Privileges to take advantage of XML export Map Data Order: #; 1 - CREATE_FUNCTION #; 2 - DROP_FUNCTION #; 3 - CREATE_METHOD #; 4 - DROP_METHOD #; 5 - CREATE_PROCEDURE #; 6 - DROP_PROCEDURE #; 7 - CREATE_QUERY #; 8 - DROP_QUERY #; 9 - CREATE_TABLE #; 10 - ALTER_TABLE #; 11 - DROP_TABLE #; 12 - CREATE_VIEW #; 13 - ALTER_VIEW #; 14 - DROP_VIEW #; 15 - CREATE_TRIGGER #; 16 - DROP_TRIGGER #; 17 - NOCHECK #; 18 - NOTRIGGER #; 19 - NOINDEX #; 20 - NOLOCK #; 21 - BUILD_INDEX #; 22 - CREATE_ML_CONFIGURATION #; 23 - ALTER_ML_CONFIGURATION #; 24 - DROP_ML_CONFIGURATION #; 25 - MANAGE_MODEL #; 26 - USE_MODEL #; 27 - DROP_UNOWNED #; 28 - NOJOURN #; 29 - CANCEL_QUERY.

Member Function Documentation

◆ Export()

_.Library.Status Export	(	_.Library.String	FileName,
		_.Library.Integer	NumExported
	)

static

This method exports SQL Admin Privilege Set records to a file in xml format.

Parameters:
Filename - Output file name
NumExported (byref) - Returns number of records exported.

◆ Import()

_.Library.Status Import	(	_.Library.String	FileName,
		_.Library.Integer	NumImported,
		_.Library.Integer	Flags
	)

static

Import SQLAdminPrivilegeSet records from an xml file.

Parameters:
FileName - Filename to import Role records from
NumImported (byref) - Returns number of records imported
Flags - Control import
Bit 0 - Do not import records, just return count
Note: On failure, no records will be imported

Member Data Documentation

◆ AlterMLConfiguration

AlterMLConfiguration

AlterMLConfiguration - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ AlterTable

AlterTable

AlterTable - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ AlterView

AlterView

AlterView - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ BuildIndex

BuildIndex

BuildIndex - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ CancelQuery

CancelQuery

CancelQuery - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ CreateFunction

CreateFunction

CreateFunction - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ CreateMLConfiguration

CreateMLConfiguration

CreateMLConfiguration - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ CreateMethod

CreateMethod

CreateMethod - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ CreateProcedure

CreateProcedure

CreateProcedure - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ CreateQuery

CreateQuery

CreateQuery - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ CreateTable

CreateTable

CreateTable - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ CreateTrigger

CreateTrigger

CreateTrigger - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ CreateView

CreateView

CreateView - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ DropFunction

DropFunction

DropFunction - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ DropMLConfiguration

DropMLConfiguration

DropMLConfiguration - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ DropMethod

DropMethod

DropMethod - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ DropProcedure

DropProcedure

DropProcedure - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ DropQuery

DropQuery

DropQuery - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ DropTable

DropTable

DropTable - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ DropTrigger

DropTrigger

DropTrigger - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ DropUnowned

DropUnowned

DropUnowned - 0/1/2, can this user is allowed to drop any sql object they are not the owner of 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ DropView

DropView

DropView - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ Grantee

Grantee

Grantee - user/role the privilege was granted to.

◆ ManageModel

ManageModel

ManageModel - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ Namespace

Namespace

Namespace the privilege is defined in.

◆ NoCheck

NoCheck

NoCheck - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ NoIndex

NoIndex

NoIndex - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ NoJourn

NoJourn

NoJourn - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ NoLock

NoLock

NoLock - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ NoTrigger

NoTrigger

NoTrigger - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

◆ UseModel

UseModel

UseModel - 0/1/2, can this privilege be granted by the user 0 - No, 1 - Yes, 2 - Yes and grantable.

Static Public Member Functions

Public Attributes