UserProfile Property
The UserProfile property returns a high-level role description for the Microsoft® SQL Server™ 2000 login or database user used by the current connection.
Applies To
| Database Object | SQLServer Object |
Syntax
object.UserProfile
Parts
object
Expression that evaluates to an object in the Applies To list
Data Type
Long, enumerated
Modifiable
Read-only
Prototype (C/C++)
For the Database object:
HRESULT GetUserProfile(SQLDMO_DBUSERPROFILE_TYPE* pRetVal)
For the SQLServer object:
HRESULT GetUserProfile(SQLDMO_SRVUSERPROFILE_TYPE* pRetVal)
Returns
For the Database object, interpret the UserProfile property using these SQLDMO_DBUSERPROFILE_TYPE values.
| Constant | Value | Description |
|---|---|---|
| SQLDMODbUserProf_AllProfileBits | 1023 | User has all specifiable database maintenance permissions. |
| SQLDMODbUserProf_CreateDefault | 32 | User has permission to execute the CREATE DEFAULT statement. |
| SQLDMODbUserProf_CreateFunction | 512 | User has permission to execute the CREATE FUNCTION statement. |
| SQLDMODbUserProf_CreateProcedure | 8 | User has permission to execute the CREATE PROCEDURE statement. |
| SQLDMODbUserProf_CreateRule | 128 | User has permission to execute the CREATE RULE statement. |
| SQLDMODbUserProf_CreateTable | 2 | User has permission to execute the CREATE TABLE statement. |
| SQLDMODbUserProf_CreateView | 4 | User has permission to execute the CREATE VIEW statement. |
| SQLDMODbUserProf_DbNotAvailable | -1073741824 | Unable to determine user permissions due to offline or other error. |
| SQLDMODbUserProf_DboLogin | 1 | User is a member of the db_owner role. |
| SQLDMODbUserProf_DumpDatabase | 16 | User can back up data for the referenced database. |
| SQLDMODbUserProf_DumpTransaction | 64 | User can back up the transaction log of the referenced database. |
| SQLDMODbUserProf_DumpTable | 256 | User can back up database data specifying a table as the backup unit. |
| SQLDMODbUserProf_InaccessibleDb | -2147483648 | Referenced database is offline or is otherwise inaccessible. |
| SQLDMODbUserProf_InvalidLogin | 1073741824 | Current connection login has no user privilege in the referenced database. |
| SQLDMODbUserProf_None | 0 | User has no database modification or maintenance permissions. |
For the SQLServer object, interpret the UserProfile property using these values.
| Constant | Value | Description |
|---|---|---|
| SQLDMOSrvUserProf_AllProfileBits | 7 | Login has all specifiable SQL Server maintenance permissions. |
| SQLDMOSrvUserProf_CreateDatabase | 2 | Login has CREATE DATABASE permission. |
| SQLDMOSrvUserProf_CreateXP | 4 | Login can execute sp_addextendedproc and sp_dropextendedproc (loading and unloading extended stored procedures). |
| SQLDMOSrvUserProf_None | 0 | Login has no SQL Server maintenance permission. |
| SQLDMOSrvUserProf_SaLogin | 1 | Login is a member of the sysadmin role. |
Remarks
SQL Server login and user permission is enhanced in an instance of SQL Server version 7.0. Fixed server and database roles allow greater granularity in specifying maintenance of an instance of SQL Server. For more information, see DatabaseRole Object and ServerRole Object.