This documentation is archived and is not being maintained.

UserProfile Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The UserProfile property returns a high-level role description for the Microsoft SQL Server login or database user used by the current connection.


object
.UserProfile

object

An expression that evaluates to an object in the Applies To list.

Long, enumerated

Read-only

For the Database object:

HRESULT GetUserProfile(SQLDMO_DBUSERPROFILE_TYPE* pRetVal)

For the SQLServer object:

HRESULT GetUserProfile(SQLDMO_SRVUSERPROFILE_TYPE* pRetVal)

For the Database object, interpret the UserProfile property using these SQLDMO_DBUSERPROFILE_TYPE values.

Constant Value Description

SQLDMODbUserProf_/AllProfileBits

1023

The user has all specifiable database maintenance permissions.

SQLDMODbUserProf_/CreateDefault

32

The user has permission to execute the CREATE DEFAULT statement.

SQLDMODbUserProf_/CreateFunction

512

The user has permission to execute the CREATE FUNCTION statement.

SQLDMODbUserProf_/CreateProcedure

8

The user has permission to execute the CREATE PROCEDURE statement.

SQLDMODbUserProf_/CreateRule

128

The user has permission to execute the CREATE RULE statement.

SQLDMODbUserProf_/CreateTable

2

The user has permission to execute the CREATE TABLE statement.

SQLDMODbUserProf_/CreateView

4

The user has permission to execute the CREATE VIEW statement.

SQLDMODbUserProf_/DbNotAvailable

-1073741824

User permissions could not be determined due to offline or other error.

SQLDMODbUserProf_/DboLogin

1

The user is a member of the db_owner role.

SQLDMODbUserProf_/DumpDatabase

16

The user has permission to back up data for the referenced database.

SQLDMODbUserProf_/DumpTable

256

The user can back up database data, specifying a table as the backup unit.

SQLDMODbUserProf_/DumpTransaction

64

The user can back up the transaction log of the referenced database.

SQLDMODbUserProf_/InaccessibleDb

-2147483648

The referenced database is offline or is otherwise inaccessible.

SQLDMODbUserProf_/InvalidLogin

1073741824

The current connection login has no user permissions in the referenced database.

SQLDMODbUserProf_None

0

The 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

The login has all specifiable SQL Server maintenance permissions.

SQLDMOSrvUserProf_/CreateDatabase

2

The login has CREATE DATABASE permission.

SQLDMOSrvUserProf_/CreateXP

4

The login can execute sp_addextendedproc and sp_dropextendedproc (loading and unloading extended stored procedures).

SQLDMOSrvUserProf_None

0

The login has no SQL Server maintenance permission.

SQLDMOSrvUserProf_/SaLogin

1

The login is a member of the sysadmin role.

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.

Show: