sp_ModifyGroupProperty

Advantage SQL Engine

Sets one property associated with a database user group in the data dictionary.

Syntax

sp_ModifyGroupProperty(

GroupName,CHARACTER,100,

Property,CHARACTER,200,

Value,MEMO )

Parameters

GroupName (I)	Name of the database user group object to set the associated property.
Property (I)	Name of a database user group property to set. See Remarks for allowed values.
Property (I)	Value to be stored in the property.

Special Return Codes

AE_INVALID_OBJECT_NAME

Possible causes for the error is that the pucUserGroupName does not specify a valid user group in the database.

Remarks

sp_ModifyGroupProperty sets one property associated with the specified user group. The new property overwrites the existing property in the data dictionary. The following are the valid values of Property and the expected values.

usPropertyID	Description
COMMENT	Stores a new description for the user group.

Example

After making a connection to the database, store a new description for the user group "Managers".

EXECUTE PROCEDURE sp_ModifyGroupProperty(

‘Managers ‘,

‘COMMENT’,

‘Managers of the Data Product Division.’ );

See Also

sp_RemoveUserFromGroup