Table: Administrator
This table contains two kinds of entries:
1.Scout administrator profiles (identified by setting Type=-1
and ID=-1)
2. Administrator policies/object rights on either a device or an
OU/group (identified by Type=1|4 and ID>=0)
The Rights attribute is a 210 bit long string, each bit represents a single permission. In order to create Administrator entries manually, it is good practice to add a new entry via Scout and copy the Rights value to your new entry.
ColumnName | DataType | Key | Not Null | Default Value | Comment | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AdministratorID | INTEGER | PK | NN | Unique ID of administrator entry | ||||||||||
Name | NVARCHAR(255) | Name of real user or group (f.e. <server>\<user>) | ||||||||||||
Sid | NVARCHAR(255) | - not used - | ||||||||||||
Rights | NVARCHAR(255) | 0000000000000000000000000000000000000000000000000000
|
||||||||||||
Type | INTEGER |
|
||||||||||||
ID | INTEGER |
For Type=1, the foreign key refers to table Device.DeviceID, |
||||||||||||
ProfileType | SMALLINT(6) |
Pre-defined profiles (administrator profiles only):
|
||||||||||||
ReservedString1 | NVARCHAR(255) | |||||||||||||
ReservedString2 | NVARCHAR(255) | |||||||||||||
ReservedInt1 | INTEGER | 0 | Optional ID
of root OU Refers to table Groups.GroupID |
|||||||||||
ReservedInt2 | INTEGER |
IndexName | IndexType | Columns |
---|---|---|
PRIMARY | PRIMARY | AdministratorID |
how to create
CREATE TABLE Administrator(
AdministratorID INTEGER NOT NULL,
Name NVARCHAR(255),
Sid NVARCHAR(255),
Rights NVARCHAR(255),
Type INTEGER,
ID INTEGER,
ProfileType SMALLINT,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (AdministratorID));