2007-01-09

Kullanıcı Hakları

Bir kullanıcının hangi veritabanı üzerinde hangi haklarının olduğunu master veritabanı üzerinde bulunan syslogins tablosundan alabiliriz. Aşağıdaki SQL ile tüm bu bilgileri görebilirsiniz:

SELECT * FROM master.dbo.syslogins

Tablo yapısı:

ColumnNameDataType Description
sidvarbinary(85)Security identifier.
statussmallintFor internal use only.
createdatedatetimeDate the login was added.
updatedatedatetimeDate the login was updated.
accdatedatetimeFor internal use only.
totcpuintFor internal use only.
totiointFor internal use only.
spacelimitintFor internal use only.
timelimitintFor internal use only.
resultlimitintFor internal use only.
namevarchar(30)Login ID of the user.
dbnamenvarchar(128)Name of the user's default database when connection is established.
passwordnvarchar(128)Encrypted password of the user (may be NULL).
languagenvarchar(128)User's default language.
denyloginint1, if login is a Microsoft® Windows NT® user or group and has been denied access.
hasaccessint1, if login has been granted access to the server.
isntnameint1 if login is a Windows NT user or group; 0 if the login is a Microsoft SQL Server™ login.
isntgroupint1, if login is a Windows NT group.
isntuserint1, if login is a Windows NT user.
sysadminint1, if login is a member of the sysadmin server role.
securityadminint1, if login is a member of the securityadmin server role.
serveradminint1, if login is a member of the serveradmin fixed server role.
setupadminint1, if login is a member of the setupadmin fixed server role.
processadminint1, if login is a member of the processadmin fixed server role.
diskadminint1, if login is a member of the diskadmin fixed server role.
dbcreatorint1, if login is a member of the dbcreator fixed server role.
loginnamenvarchar(128)Actual name of the login, which may be different from the login name used by SQL Server.

Hiç yorum yok:

.::YASAL UYARI::.

©2004-2016 Mehmet GÜZEL, http://www.mehmetguzel.net/ & http://www.mehmetguzel.com/

Site içeriği kaynak gösterilmek koşuluyla yayınlanabilir. Yazılan yazı ve yorumlar sadece yazı ve yorum sahiplerini bağlar.