![NEAREST_CENTURY option [TSQL]](arrow-right.gif){kind=icon}
Lets a query server create and drop users, groups, and group memberships.
0 – 63
A bitmask indicating the corresponding special privileges to be granted and revoked on a query server:
0x01 = DBA
0x02 = create user through GRANT CONNECT and drop user through REVOKE CONNECT
0x04 = RESOURCE
0x10 = GROUP
0x20 = MEMBERSHIP
To
combine two or more privileges, add the bitmasks in hexadecimal
(base 16), then convert to decimal to determine the value for the
option. For example, to combine RESOURCE and GROUP privileges
on a database, use the formula 4 + 16
(10 in base 16) = 20 and set MPX_LOCAL_SPEC_PRIV to
20.
To allow all privileges, you must set all bits. To do this, set MPX_LOCAL_SPEC_PRIV to 63.
Can be set only for the PUBLIC group. Takes effect immediately.
0
To enable MPX_LOCAL_SPEC_PRIV, set it to the appropriate value between 1 and 63. See “Allowed values”. DBA permissions are required to set this option. This option takes effect immediately.
