%EM.DistSQLSecurity
class %EM.DistSQLSecurity extends %Library.RegisteredObject, %XML.Adaptor
Enterprise Manager distributed SQL Security APIMethod Inventory
Methods
Execute an SQL command to update SQL Security meta-data. Updates can be made on an instance that is a member of an Enterprise Management group that manages the Distributed SQL Security service. Updates made with Enterprise Manager Distributed SQL Security API class are first applied locally and then distributed to other instances in the EM group containing the Distributed SQL Security service.
The command argument is a string containing a valid SQL security command from the following set: "CREATE USER", "DROP USER", "CREATE ROLE", "DROP ROLE", "GRANT" and "REVOKE". Any valid command syntax from this set of commands is acceptable. Other SQL commands (examples: "CREATE TABLE", "DROP VIEW", "SELECT") are not supported and will return an error status.
Example commands:
Example commands:
- CREATE USER UserName IDENTIFIED BY Password
- DROP USER UserName
- CREATE ROLE RoleName
- DROP ROLE RoleName
- GRANT RoleName TO UserName
- GRANT PrivilegeName TO RoleName
- REVOKE RoleName FROM UserName
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %ClassIsLatestVersion()
- %ClassName()
- %ConstructClone()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Extends()
- %GetParameter()
- %IsA()
- %IsModified()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OriginalNamespace()
- %PackageName()
- %RemoveFromSaveSet()
- %SerializeObject()
- %SetModified()
- %ValidateObject()
- XMLDTD()
- XMLExport()
- XMLExportToStream()
- XMLExportToString()
- XMLNew()
- XMLSchema()
- XMLSchemaNamespace()
- XMLSchemaType()