Advantage SQL Engine
Sets one property associated with a database user group in the data dictionary.
sp_ModifyGroupProperty(
GroupName,CHARACTER,100,
Property,CHARACTER,200,
Value,MEMO )
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. |
AE_INVALID_OBJECT_NAME |
Possible causes for the error is that the pucUserGroupName does not specify a valid user group in the database. |
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. |
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