Northwind Schema Report (security report)

Table of Contents

Summary

PropertyValue
Report created31-Oct-2005 21:23
DBMS and versionMicrosoft SQL Server [ 08.00.0760 ]
ServerTOSHIBA2
Database nameNorthwind
User/Login 
Schema/Owner 
Driver and versionSQLSRV32.DLL [ 03.85.1117 ]

Users, 9 items

Login NameDefault DBLanguageis user
AdminAppUsermasterus_englishyes
AspUsermasterus_englishno
BUILTIN-Administratorsmasterus_englishno
I.ShekalevtestDBus_englishyes
IDD_GuestDAFASQLus_englishno
IDD_ReportsDAFASQLus_englishyes
IDD_WebUserDAFASQLus_englishyes
fshopuserFrameshopus_englishyes
samaster yes

Database roles for login 'AdminAppUser', 4 items

DatabaseRoles
HCECGpublic, db_owner
dbSitepublic, db_owner
intranetpublic, db_owner
jacobpublic, db_owner

Database roles for login 'I.Shekalev', 10 items

DatabaseRoles
DAFASQLpublic, db_owner
DTM-SALESpublic, db_owner
Frameshoppublic
Northwindpublic
masterpublic
modelpublic
msdbpublic
pubspublic
tempdbpublic
testDBpublic, db_owner

Database roles for login 'IDD_Reports', 1 item

DatabaseRoles
DAFASQLpublic

Database roles for login 'IDD_WebUser', 1 item

DatabaseRoles
DAFASQLpublic

Database roles for login 'fshopuser', 1 item

DatabaseRoles
Frameshoppublic

Database roles for login 'sa', 6 items

DatabaseRoles
Northwindpublic, db_owner
masterpublic, db_owner
modelpublic, db_owner
msdbpublic, db_owner
pubspublic, db_owner
tempdbpublic, db_owner

Roles, 10 items

Role NameMembersIs App Role
public No
db_ownerdboNo
db_accessadmin No
db_securityadmin No
db_ddladmin No
db_backupoperator No
db_datareader No
db_datawriter No
db_denydatareader No
db_denydatawriter No

Permissions for role 'db_owner', 63 items

Permission
Add/drop to/from db_accessadmin
Add/drop to/from db_backupoperator
Add/drop to/from db_datareader
Add/drop to/from db_datawriter
Add/drop to/from db_ddladmin
Add/drop to/from db_denydatareader
Add/drop to/from db_denydatawriter
Add/drop to/from db_owner
Add/drop to/from db_securityadmin
All DDL but GRANT, REVOKE, DENY
BACKUP DATABASE
BACKUP LOG
CHECKPOINT
DELETE permission on any object
DENY
EXECUTE any procedure
GRANT
INSERT permission on any object
REFERENCES permission on any table
REVOKE
SELECT permission on any object
TRUNCATE TABLE
UPDATE permission on any object
dbcc checkalloc
dbcc checkdb
dbcc checkfilegroup
dbcc checkident
dbcc checktable
dbcc cleantable
dbcc dbreindex
dbcc proccache
dbcc show_statistics
dbcc showcontig
dbcc shrinkdatabase
dbcc shrinkfile
dbcc updateusage
sp_addalias
sp_addapprole
sp_addgroup
sp_addrole
sp_addrolemember
sp_approlepassword
sp_change_users_login
sp_changegroup
sp_changeobjectowner
sp_dbcmptlevel
sp_dboption (update)
sp_dropalias
sp_dropapprole
sp_dropgroup
sp_droprole
sp_droprolemember
sp_dropuser
sp_fulltext_catalog
sp_fulltext_column
sp_fulltext_database
sp_fulltext_table
sp_grantdbaccess
sp_recompile
sp_refreshview
sp_rename
sp_revokedbaccess
sp_tableoption

Permissions for role 'db_accessadmin', 5 items

Permission
sp_addalias
sp_dropalias
sp_dropuser
sp_grantdbaccess
sp_revokedbaccess

Permissions for role 'db_securityadmin', 14 items

Permission
DENY
GRANT
REVOKE
sp_addapprole
sp_addgroup
sp_addrole
sp_addrolemember
sp_approlepassword
sp_changegroup
sp_changeobjectowner
sp_dropapprole
sp_dropgroup
sp_droprole
sp_droprolemember

Permissions for role 'db_ddladmin', 12 items

Permission
All DDL but GRANT, REVOKE, DENY
REFERENCES permission on any table
TRUNCATE TABLE
dbcc cleantable
dbcc show_statistics
dbcc showcontig
sp_changeobjectowner
sp_fulltext_column
sp_fulltext_table
sp_recompile
sp_rename
sp_tableoption

Permissions for role 'db_backupoperator', 3 items

Permission
BACKUP DATABASE
BACKUP LOG
CHECKPOINT

Permissions for role 'db_datareader', 1 item

Permission
SELECT permission on any object

Permissions for role 'db_datawriter', 3 items

Permission
DELETE permission on any object
INSERT permission on any object
UPDATE permission on any object

Permissions for role 'db_denydatareader', 1 item

Permission
No SELECT permission on any object

Permissions for role 'db_denydatawriter', 3 items

Permission
No DELETE permission on any object
No INSERT permission on any object
No UPDATE permission on any object

Server Roles, 8 items

Role Name
sysadmin
securityadmin
serveradmin
setupadmin
processadmin
diskadmin
dbcreator
bulkadmin

Permissions for server role 'sysadmin', 130 items

Permission
ALTER DATABASE
Add extended procedures
Add member to bulkadmin
Add member to dbcreator
Add member to diskadmin
Add member to processadmin
Add member to securityadmin
Add member to serveradmin
Add member to setupadmin
Add member to sysadmin
Add/drop to/from db_accessadmin
Add/drop to/from db_backupoperator
Add/drop to/from db_datareader
Add/drop to/from db_datawriter
Add/drop to/from db_ddladmin
Add/drop to/from db_denydatareader
Add/drop to/from db_denydatawriter
Add/drop to/from db_owner
Add/drop to/from db_securityadmin
Add/drop/configure linked servers
All DDL but GRANT, REVOKE, DENY
BACKUP DATABASE
BACKUP LOG
BULK INSERT
CHECKPOINT
CREATE DATABASE
Complete SETUSER SQL user
Constraints on System tables
Create indices on system tables
Create/delete/modify system tables
DBCC ShrinkDatabase
DBCC ShrinkFile
DELETE permission on any object
DENY
DISK INIT
DROP DATABASE
EXECUTE any procedure
Extend database
GRANT
Grant/deny/revoke CREATE DATABASE
INSERT permission on any object
KILL
Mark a stored procedure as startup
RECONFIGURE
REFERENCES permission on any table
RESTORE DATABASE
RESTORE LOG
REVOKE
Raiserror With Log
Read the error log
SELECT permission on any object
SHUTDOWN
TRUNCATE TABLE
UPDATE permission on any object
USE to a suspect database
dbcc change 'on' rules
dbcc checkalloc
dbcc checkdb
dbcc checkfilegroup
dbcc checkident
dbcc checktable
dbcc cleantable
dbcc dbreindex
dbcc dropcleanbuffers
dbcc freeproccache
dbcc inputbuffer
dbcc outputbuffer
dbcc pintable
dbcc proccache
dbcc setcpuweight
dbcc setioweight
dbcc show_statistics
dbcc showcontig
dbcc showoptweights
dbcc shrinkdatabase
dbcc shrinkfile
dbcc traceon/off
dbcc updateusage
sp_addalias
sp_addapprole
sp_addgroup
sp_addlinkedsrvlogin
sp_addlogin
sp_addrole
sp_addrolemember
sp_addumpdevice
sp_adduser
sp_altermessage
sp_approlepassword
sp_change_users_login
sp_changedbowner
sp_changegroup
sp_changeobjectowner
sp_configure
sp_dbcmptlevel
sp_dboption (update)
sp_dboption update part
sp_defaultdb
sp_defaultlanguage
sp_denylogin
sp_diskdefault
sp_dropalias
sp_dropapprole
sp_dropdevice
sp_dropgroup
sp_droplinkedsrvlogin
sp_droplogin
sp_dropremotelogin
sp_droprole
sp_droprolemember
sp_dropuser
sp_fulltext_catalog
sp_fulltext_column
sp_fulltext_database
sp_fulltext_service
sp_fulltext_table
sp_grantdbaccess
sp_grantlogin
sp_helplogins
sp_password
sp_recompile
sp_refreshview
sp_remoteoption
sp_remoteoption (update)
sp_rename
sp_renamedb
sp_revokedbaccess
sp_revokelogin
sp_tableoption
sp_updatestats

Permissions for server role 'securityadmin', 16 items

Permission
Add member to securityadmin
Grant/deny/revoke CREATE DATABASE
Read the error log
sp_addlinkedsrvlogin
sp_addlogin
sp_defaultdb
sp_defaultlanguage
sp_denylogin
sp_droplinkedsrvlogin
sp_droplogin
sp_dropremotelogin
sp_grantlogin
sp_helplogins
sp_password
sp_remoteoption (update)
sp_revokelogin

Permissions for server role 'serveradmin', 7 items

Permission
Add member to serveradmin
RECONFIGURE
SHUTDOWN
dbcc freeproccache
sp_configure
sp_fulltext_service
sp_tableoption

Permissions for server role 'setupadmin', 3 items

Permission
Add member to setupadmin
Add/drop/configure linked servers
Mark a stored procedure as startup

Permissions for server role 'processadmin', 2 items

Permission
Add member to processadmin
KILL

Permissions for server role 'diskadmin', 5 items

Permission
Add member to diskadmin
DISK INIT
sp_addumpdevice
sp_diskdefault
sp_dropdevice

Permissions for server role 'dbcreator', 8 items

Permission
ALTER DATABASE
Add member to dbcreator
CREATE DATABASE
DROP DATABASE
Extend database
RESTORE DATABASE
RESTORE LOG
sp_renamedb

Permissions for server role 'bulkadmin', 2 items

Permission
Add member to bulkadmin
BULK INSERT

Permissions by Database Objects

Permissions for 'dbo.Categories' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.CustomerCustomerDemo' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.CustomerDemographics' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Customers' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.DESCRIP3' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.DESCRIP32' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.EmployeeTerritories' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Employees' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.MyValues' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Order Details' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Orders' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Products' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Region' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Shippers' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Suppliers' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Territories' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.TwoCols' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo._TimeS' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.dtproperties' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.test2' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.test_scr' (table), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Alphabetical list of products' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Category Sales for 1997' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Current Product List' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Customer and Suppliers by City' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Invoices' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Order Details Extended' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Order Subtotals' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Orders Qry' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Product Sales for 1997' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Products Above Average Price' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Products by Category' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Quarterly Orders' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Sales Totals by Amount' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Sales by Category' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Summary of Sales by Quarter' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.Summary of Sales by Year' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.qwe' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.sysconstraints' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES

Permissions for 'dbo.syssegments' (view), 5 items

Login NameAcces rightGrantorGrantable
dboDELETEdboYES
dboINSERTdboYES
dboREFERENCESdboYES
dboSELECTdboYES
dboUPDATEdboYES