Adventure Works Database Schema (security report)

Summary

Property	Value
Report created	20-May-2011 16:08
DBMS and version	Microsoft SQL Server [ 09.00.1399 ]
Server	DTM-XP
Database name	AdventureWorks
User/Login	sa
Schema/Owner
Driver and version	sqlncli10.dll [ 10.00.4000 ]
DTM Schema Reporter	Version 1.24.23, (C) 2003-2011 DTM soft.

Users, 12 items

Login Name	Default DB	Language	is user
##MS_AgentSigningCertificate##	master	us_english	yes
##MS_SQLAuthenticatorCertificate##	master		no
##MS_SQLReplicationSigningCertificate##	master		no
##MS_SQLResourceSigningCertificate##	master		no
Admin	MergeDICOMdb	us_english	yes
BUILTIN-Administrators	master	us_english	no
dicomuser	MergeDICOMdb	us_english	yes
DTM-XP-SQLServer2005MSFTEUser$DTM-XP$MSSQLSERVER	master	us_english	yes
DTM-XP-SQLServer2005MSSQLUser$DTM-XP$MSSQLSERVER	master	us_english	no
DTM-XP-SQLServer2005SQLAgentUser$DTM-XP$MSSQLSERVER	master	us_english	no
NT AUTHORITY-SYSTEM	master	us_english	no
sa	master	us_english	yes

Database roles for login '##MS_AgentSigningCertificate##', 1 item

Database	Roles
master	public

Database roles for login 'Admin', 1 item

Database	Roles
MergeDICOMdb	public

Database roles for login 'dicomuser', 1 item

Database	Roles
MergeDICOMdb	public

Database roles for login 'DTM-XP\SQLServer2005MSFTEUser$DTM-XP$MSSQLSERVER', 1 item

Database	Roles
master	public

Database roles for login 'sa', 5 items

Database	Roles
AdventureWorks	public, db_owner
master	public, db_owner
model	public, db_owner
msdb	public, db_owner
tempdb	public, db_owner

Roles, 10 items

Role Name	Memebers	Is App Role
public		No
db_owner	dbo	No
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
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
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
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
TRUNCATE TABLE
UPDATE permission on any object

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
dbcc cleantable
dbcc show_statistics
dbcc showcontig
REFERENCES permission on any table
sp_changeobjectowner
sp_fulltext_column
sp_fulltext_table
sp_recompile
sp_rename
sp_tableoption
TRUNCATE TABLE

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', 128 items

Permission
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
ALTER DATABASE
BACKUP DATABASE
BACKUP LOG
BULK INSERT
CHECKPOINT
Complete SETUSER SQL user
Constraints on System tables
CREATE DATABASE
Create indices on system tables
Create/delete/modify system tables
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
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
Raiserror With Log
Read the error log
RECONFIGURE
REFERENCES permission on any table
RESTORE DATABASE
RESTORE LOG
REVOKE
SELECT permission on any object
SHUTDOWN
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
TRUNCATE TABLE
UPDATE permission on any object
USE to a suspect database

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
dbcc freeproccache
RECONFIGURE
SHUTDOWN
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
Add member to dbcreator
ALTER DATABASE
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.AWBuildVersion' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

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

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

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

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.Department' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.Employee' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.EmployeeAddress' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.EmployeeDepartmentHistory' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.EmployeePayHistory' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.JobCandidate' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.Shift' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Person.Address' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Person.AddressType' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Person.Contact' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Person.ContactType' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Person.CountryRegion' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Person.StateProvince' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.BillOfMaterials' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.Culture' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.Document' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.Illustration' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.Location' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.Product' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductCategory' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductCostHistory' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductDescription' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductDocument' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductInventory' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductListPriceHistory' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductModel' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductModelIllustration' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductModelProductDescriptionCulture' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductPhoto' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductProductPhoto' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductReview' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ProductSubcategory' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.ScrapReason' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.TransactionHistory' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.TransactionHistoryArchive' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.UnitMeasure' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.WorkOrder' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.WorkOrderRouting' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Purchasing.ProductVendor' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Purchasing.PurchaseOrderDetail' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Purchasing.PurchaseOrderHeader' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Purchasing.ShipMethod' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Purchasing.Vendor' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Purchasing.VendorAddress' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Purchasing.VendorContact' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.ContactCreditCard' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.CountryRegionCurrency' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.CreditCard' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.Currency' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.CurrencyRate' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.Customer' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.CustomerAddress' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.Individual' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.SalesOrderDetail' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.SalesOrderHeader' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.SalesOrderHeaderSalesReason' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.SalesPerson' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.SalesPersonQuotaHistory' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.SalesReason' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.SalesTaxRate' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.SalesTerritory' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.SalesTerritoryHistory' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.ShoppingCartItem' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.SpecialOffer' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.SpecialOfferProduct' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.Store' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.StoreContact' (table), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.vEmployee' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.vEmployeeDepartment' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.vEmployeeDepartmentHistory' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.vJobCandidate' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.vJobCandidateEducation' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'HumanResources.vJobCandidateEmployment' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.CHECK_CONSTRAINTS' (view), 10 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.COLUMN_PRIVILEGES' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.COLUMNS' (view), 10 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.DOMAINS' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.KEY_COLUMN_USAGE' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.PARAMETERS' (view), 10 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.ROUTINE_COLUMNS' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.ROUTINES' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.SCHEMATA' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.TABLE_CONSTRAINTS' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.TABLE_PRIVILEGES' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.TABLES' (view), 10 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.VIEW_COLUMN_USAGE' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.VIEW_TABLE_USAGE' (view), 5 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES

Permissions for 'INFORMATION_SCHEMA.VIEWS' (view), 10 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'Person.vAdditionalContactInfo' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Person.vStateProvinceCountryRegion' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.vProductAndDescription' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.vProductModelCatalogDescription' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Production.vProductModelInstructions' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Purchasing.vVendor' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.vIndividualCustomer' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.vIndividualDemographics' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.vSalesPerson' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.vSalesPersonSalesByFiscalYears' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'Sales.vStoreWithDemographics' (view), 5 items

Login Name	Acces right	Grantor	Grantable
dbo	DELETE	dbo	YES
dbo	INSERT	dbo	YES
dbo	REFERENCES	dbo	YES
dbo	SELECT	dbo	YES
dbo	UPDATE	dbo	YES

Permissions for 'sys.all_columns' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.all_objects' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.all_parameters' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.all_sql_modules' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.all_views' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.allocation_units' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.assemblies' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.assembly_files' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.assembly_modules' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.assembly_references' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.assembly_types' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.asymmetric_keys' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.backup_devices' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.certificates' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.check_constraints' (view), 10 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.column_type_usages' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.column_xml_schema_collection_usages' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.columns' (view), 10 items

Login Name	Acces right	Grantor	Grantable
INFORMATION_SCHEMA	DELETE	dbo	YES
INFORMATION_SCHEMA	INSERT	dbo	YES
INFORMATION_SCHEMA	REFERENCES	dbo	YES
INFORMATION_SCHEMA	SELECT	dbo	YES
INFORMATION_SCHEMA	UPDATE	dbo	YES
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.computed_columns' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.configurations' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.conversation_endpoints' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.conversation_groups' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.credentials' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.crypt_properties' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.data_spaces' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.database_files' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.database_mirroring' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.database_mirroring_endpoints' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.database_mirroring_witnesses' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.database_permissions' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.database_principal_aliases' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.database_principals' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.database_recovery_status' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.database_role_members' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.databases' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.default_constraints' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.destination_data_spaces' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_broker_activated_tasks' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_broker_connections' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_broker_forwarded_messages' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_broker_queue_monitors' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_clr_appdomains' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_clr_loaded_assemblies' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_clr_properties' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_clr_tasks' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_db_file_space_usage' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_db_index_usage_stats' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_db_mirroring_connections' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_db_missing_index_details' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_db_missing_index_group_stats' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_db_missing_index_groups' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_db_partition_stats' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_db_session_space_usage' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_db_task_space_usage' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_exec_background_job_queue' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_exec_background_job_queue_stats' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_exec_cached_plans' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_exec_connections' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_exec_query_optimizer_info' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_exec_query_stats' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_exec_query_transformation_stats' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_exec_requests' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_exec_sessions' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_fts_active_catalogs' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES

Permissions for 'sys.dm_fts_index_population' (view), 5 items

Login Name	Acces right	Grantor	Grantable
sys	DELETE	dbo	YES
sys	INSERT	dbo	YES
sys	REFERENCES	dbo	YES
sys	SELECT	dbo	YES
sys	UPDATE	dbo	YES