User: [AdventureWorks2016CTP3].[amy0]

CollapseAll image

Collapse image User properties


Name  Value 
 Name   [amy0] 
 Login    
 ID   21 
 Authentication type   SQL Server 

Collapse image Roles


Role
[SalesManagers]
[public]

Collapse image Objects


Name Type
[dbo].[AccountNumber] Datatype
[dbo].[Flag] Datatype
[dbo].[Name] Datatype
[dbo].[NameStyle] Datatype
[dbo].[OrderNumber] Datatype
[dbo].[Phone] Datatype
[Sales].[SalesOrderDetailType_inmem] Datatype
[Sales].[SalesOrderDetailType_ondisk] Datatype
[AW2014FullTextCatalog] Fulltext Catalog
[dbo].[AUDIT_fn_HexToStr] Function
[dbo].[AUDIT_fn_SqlVariantToString] Function
[dbo].[ufnGetAccountingEndDate] Function
[dbo].[ufnGetAccountingEndDate_native] Function
[dbo].[ufnGetAccountingStartDate] Function
[dbo].[ufnGetAccountingStartDate_native] Function
[dbo].[ufnGetContactInformation] Function
[dbo].[ufnGetDocumentStatusText] Function
[dbo].[ufnGetDocumentStatusText_native] Function
[dbo].[ufnGetProductDealerPrice] Function
[dbo].[ufnGetProductListPrice] Function
[dbo].[ufnGetProductStandardCost] Function
[dbo].[ufnGetPurchaseOrderStatusText] Function
[dbo].[ufnGetPurchaseOrderStatusText_native] Function
[dbo].[ufnGetSalesOrderStatusText] Function
[dbo].[ufnGetSalesOrderStatusText_native] Function
[dbo].[ufnGetStock] Function
[dbo].[ufnLeadingZeros] Function
[dbo].[ufnLeadingZeros_native] Function
[Sales].[vSalesOrderDetail_extended_inmem] Function
[Sales].[vSalesOrderHeader_extended_inmem] Function
[Security].[customerAccessPredicate] Function
[dbo].[AUDIT_prc_AggregateReport] Procedure
[dbo].[AUDIT_prc_Analyze] Procedure
[dbo].[AUDIT_prc_DDLReport] Procedure
[dbo].[AUDIT_prc_DeleteArchitecture] Procedure
[dbo].[AUDIT_prc_Purge_AUDIT_LOG] Procedure
[dbo].[AUDIT_prc_ReportingAddFilterValue] Procedure
[dbo].[AUDIT_prc_ReportingEnd] Procedure
[dbo].[AUDIT_prc_ReportingStart] Procedure
[dbo].[AUDIT_prc_StandardReport] Procedure
[dbo].[uspAddOrderTrackingEvent] Procedure
[dbo].[uspGetBillOfMaterials] Procedure
[dbo].[uspGetEmployeeManagers] Procedure
[dbo].[uspGetManagerEmployees] Procedure
[dbo].[uspGetOrderTrackingBySalesOrderID] Procedure
[dbo].[uspGetOrderTrackingByTrackingNumber] Procedure
[dbo].[uspGetWhereUsedProductID] Procedure
[dbo].[uspLogError] Procedure
[dbo].[uspPrintError] Procedure
[dbo].[uspSearchCandidateResumes] Procedure
[Demo].[usp_DemoInitSeed] Procedure
[Demo].[usp_DemoReset] Procedure
[HumanResources].[sp_GetEmployee_Person_Info_AsOf] Procedure
[HumanResources].[sp_UpdateEmployee_Temporal] Procedure
[HumanResources].[uspUpdateEmployeeHireInfo] Procedure
[HumanResources].[uspUpdateEmployeeLogin] Procedure
[HumanResources].[uspUpdateEmployeePersonalInfo] Procedure
[Person].[sp_DeletePerson_Temporal] Procedure
[Person].[sp_UpdatePerson_Temporal] Procedure
[Sales].[usp_InsertSalesOrder_inmem] Procedure
[Sales].[usp_InsertSalesOrder_ondisk] Procedure
[Sales].[usp_UpdateSalesOrderShipInfo_inmem] Procedure
[Sales].[usp_UpdateSalesOrderShipInfo_native] Procedure
[Sales].[usp_UpdateSalesOrderShipInfo_ondisk] Procedure
[SQLCop].[test] Procedure
[SQLCop].[test Ad hoc distributed queries] Procedure
[SQLCop].[test Agent Service] Procedure
[SQLCop].[test Auto close] Procedure
[SQLCop].[test Auto create statistics] Procedure
[SQLCop].[test Auto Shrink] Procedure
[SQLCop].[test Auto update statistics] Procedure
[SQLCop].[test Buffer cache hit ratio] Procedure
[SQLCop].[test Column collation does not match database default] Procedure
[SQLCop].[test Column data types (Numeric vs. Int)] Procedure
[SQLCop].[test Column Name Problems] Procedure
[SQLCop].[test Columns of data type Text/nText] Procedure
[SQLCop].[test Columns with float data type] Procedure
[SQLCop].[test Columns with image data type] Procedure
[SQLCop].[test Compatibility Level] Procedure
[SQLCop].[test Database and Log files on the same disk] Procedure
[SQLCop].[test Database collation] Procedure
[SQLCop].[test Database Mail] Procedure
[SQLCop].[test Decimal Size Problem] Procedure
[SQLCop].[test Forwarded Records] Procedure
[SQLCop].[test Fragmented Indexes] Procedure
[SQLCop].[test Instant File Initialization] Procedure
[SQLCop].[test Login Language] Procedure
[SQLCop].[test Max degree of parallelism] Procedure
[SQLCop].[test Missing Foreign Key Indexes] Procedure
[SQLCop].[test Missing Foreign Keys] Procedure
[SQLCop].[test Old Backups] Procedure
[SQLCop].[test Ole Automation Procedures] Procedure
[SQLCop].[test Orphaned Users] Procedure
[SQLCop].[test Page life expectancy] Procedure
[SQLCop].[test Procedures Named SP_] Procedure
[SQLCop].[test Procedures that call undocumented procedures] Procedure
[SQLCop].[test Procedures using dynamic SQL without sp_executesql] Procedure
[SQLCop].[test Procedures with @@Identity] Procedure
[SQLCop].[test Procedures With SET ROWCOUNT] Procedure
[SQLCop].[test Procedures without SET NOCOUNT ON] Procedure
[SQLCop].[test Service Account] Procedure
[SQLCop].[test SMO and DMO] Procedure
[SQLCop].[test Table name problems] Procedure
[SQLCop].[test Tables that start with tbl] Procedure
[SQLCop].[test Tables without a primary key] Procedure
[SQLCop].[test Tables without any data] Procedure
[SQLCop].[test UniqueIdentifier with NewId] Procedure
[SQLCop].[test Unnamed Constraints] Procedure
[SQLCop].[test User Aliases] Procedure
[SQLCop].[test Varchar Size Problem] Procedure
[SQLCop].[test Views with order by] Procedure
[SQLCop].[test Wide Table] Procedure
[SQLCop].[test xp_cmdshell is enabled] Procedure
[dbo].[db_accessadmin] Role
[dbo].[db_backupoperator] Role
[dbo].[db_datareader] Role
[dbo].[db_datawriter] Role
[dbo].[db_ddladmin] Role
[dbo].[db_denydatareader] Role
[dbo].[db_denydatawriter] Role
[dbo].[db_owner] Role
[dbo].[db_securityadmin] Role
[dbo].[public] Role
[dbo].[SalesManagers] Role
[dbo].[SalesPersons] Role
[dbo].[AUDIT_LOG_DATA] Table
[dbo].[AUDIT_LOG_DDL] Table
[dbo].[AUDIT_LOG_TRANSACTIONS] Table
[dbo].[AWBuildVersion] Table
[dbo].[DatabaseLog] Table
[dbo].[ErrorLog] Table
[Demo].[DemoSalesOrderDetailSeed] Table
[Demo].[DemoSalesOrderHeaderSeed] Table
[HumanResources].[Department] Table
[HumanResources].[Employee] Table
[HumanResources].[Employee_Temporal] Table
[HumanResources].[Employee_Temporal_History] Table
[HumanResources].[EmployeeDepartmentHistory] Table
[HumanResources].[EmployeePayHistory] Table
[HumanResources].[JobCandidate] Table
[HumanResources].[Shift] Table
[Person].[Address] Table
[Person].[AddressType] Table
[Person].[BusinessEntity] Table
[Person].[BusinessEntityAddress] Table
[Person].[BusinessEntityContact] Table
[Person].[ContactType] Table
[Person].[CountryRegion] Table
[Person].[EmailAddress] Table
[Person].[Password] Table
[Person].[Person] Table
[Person].[Person_json] Table
[Person].[Person_Temporal] Table
[Person].[Person_Temporal_History] Table
[Person].[PersonPhone] Table
[Person].[PhoneNumberType] Table
[Person].[StateProvince] Table
[Production].[BillOfMaterials] Table
[Production].[Culture] Table
[Production].[Document] Table
[Production].[Illustration] Table
[Production].[Location] Table
[Production].[Product] Table
[Production].[Product_inmem] Table
[Production].[Product_ondisk] Table
[Production].[ProductCategory] Table
[Production].[ProductCostHistory] Table
[Production].[ProductDescription] Table
[Production].[ProductDocument] Table
[Production].[ProductInventory] Table
[Production].[ProductListPriceHistory] Table
[Production].[ProductModel] Table
[Production].[ProductModelIllustration] Table
[Production].[ProductModelProductDescriptionCulture] Table
[Production].[ProductPhoto] Table
[Production].[ProductProductPhoto] Table
[Production].[ProductReview] Table
[Production].[ProductSubcategory] Table
[Production].[ScrapReason] Table
[Production].[TransactionHistory] Table
[Production].[TransactionHistoryArchive] Table
[Production].[UnitMeasure] Table
[Production].[WorkOrder] Table
[Production].[WorkOrderRouting] Table
[Purchasing].[ProductVendor] Table
[Purchasing].[PurchaseOrderDetail] Table
[Purchasing].[PurchaseOrderHeader] Table
[Purchasing].[ShipMethod] Table
[Purchasing].[Vendor] Table
[Sales].[CountryRegionCurrency] Table
[Sales].[CreditCard] Table
[Sales].[Currency] Table
[Sales].[CurrencyRate] Table
[Sales].[Customer] Table
[Sales].[CustomerPII] Table
[Sales].[OrderTracking] Table
[Sales].[PersonCreditCard] Table
[Sales].[SalesOrder_json] Table
[Sales].[SalesOrderDetail] Table
[Sales].[SalesOrderDetail_inmem] Table
[Sales].[SalesOrderDetail_ondisk] Table
[Sales].[SalesOrderHeader] Table
[Sales].[SalesOrderHeader_inmem] Table
[Sales].[SalesOrderHeader_ondisk] Table
[Sales].[SalesOrderHeaderSalesReason] Table
[Sales].[SalesPerson] Table
[Sales].[SalesPersonQuotaHistory] Table
[Sales].[SalesReason] Table
[Sales].[SalesTaxRate] Table
[Sales].[SalesTerritory] Table
[Sales].[SalesTerritoryHistory] Table
[Sales].[ShoppingCartItem] Table
[Sales].[SpecialOffer] Table
[Sales].[SpecialOffer_inmem] Table
[Sales].[SpecialOffer_ondisk] Table
[Sales].[SpecialOfferProduct] Table
[Sales].[SpecialOfferProduct_inmem] Table
[Sales].[SpecialOfferProduct_ondisk] Table
[Sales].[Store] Table
[Sales].[TrackingEvent] Table
[dbo].[tr_d_AUDIT_AWBuildVersion] Trigger
[dbo].[tr_d_AUDIT_DatabaseLog] Trigger
[dbo].[tr_d_AUDIT_ErrorLog] Trigger
[dbo].[tr_i_AUDIT_DatabaseLog] Trigger
[dbo].[tr_i_AUDIT_ErrorLog] Trigger
[dbo].[tr_u_AUDIT_AWBuildVersion] Trigger
[dbo].[tr_u_AUDIT_DatabaseLog] Trigger
[HumanResources].[dEmployee] Trigger
[HumanResources].[tr_d_AUDIT_Department] Trigger
[HumanResources].[tr_d_AUDIT_Employee] Trigger
[HumanResources].[tr_d_AUDIT_EmployeeDepartmentHistory] Trigger
[HumanResources].[tr_d_AUDIT_EmployeePayHistory] Trigger
[HumanResources].[tr_i_AUDIT_Department] Trigger
[HumanResources].[tr_i_AUDIT_Employee] Trigger
[HumanResources].[tr_i_AUDIT_EmployeeDepartmentHistory] Trigger
[HumanResources].[tr_i_AUDIT_EmployeePayHistory] Trigger
[HumanResources].[tr_u_AUDIT_Department] Trigger
[HumanResources].[tr_u_AUDIT_Employee_Temporal] Trigger
[HumanResources].[tr_u_AUDIT_EmployeeDepartmentHistory] Trigger
[HumanResources].[tr_u_AUDIT_EmployeePayHistory] Trigger
[Person].[iuPerson] Trigger
[Production].[iWorkOrder] Trigger
[Production].[uWorkOrder] Trigger
[Purchasing].[dVendor] Trigger
[Purchasing].[iPurchaseOrderDetail] Trigger
[Purchasing].[uPurchaseOrderDetail] Trigger
[Purchasing].[uPurchaseOrderHeader] Trigger
[Sales].[iduSalesOrderDetail] Trigger
[Sales].[uSalesOrderHeader] Trigger
[amy0] User
[brian3] User
[david8] User
[dbo] User
[garrett1] User
[guest] User
[jae0] User
[jillian0] User
[josé1] User
[linda3] User
[lynn0] User
[michael9] User
[pamela0] User
[rachel0] User
[ranjit0] User
[shu0] User
[stephen0] User
[syed0] User
[tete0] User
[tsvi0] User
[dbo].[AUDIT_UNDO] View
[dbo].[AUDIT_VIEW] View
[HumanResources].[vEmployee] View
[HumanResources].[vEmployeeDepartment] View
[HumanResources].[vEmployeeDepartmentHistory] View
[HumanResources].[vEmployeePersonTemporalInfo] View
[HumanResources].[vJobCandidate] View
[HumanResources].[vJobCandidateEducation] View
[HumanResources].[vJobCandidateEmployment] View
[Person].[vAdditionalContactInfo] View
[Person].[vStateProvinceCountryRegion] View
[Production].[vProductAndDescription] View
[Production].[vProductModelCatalogDescription] View
[Production].[vProductModelInstructions] View
[Purchasing].[vVendorWithAddresses] View
[Purchasing].[vVendorWithContacts] View
[Sales].[vIndividualCustomer] View
[Sales].[vPersonDemographics] View
[Sales].[vSalesPerson] View
[Sales].[vSalesPersonSalesByFiscalYears] View
[Sales].[vStoreWithAddresses] View
[Sales].[vStoreWithContacts] View
[Sales].[vStoreWithDemographics] View
[tr_ddl_AUDIT] DDL Trigger
[db_accessadmin] Schema
[db_backupoperator] Schema
[db_datareader] Schema
[db_datawriter] Schema
[db_ddladmin] Schema
[db_denydatareader] Schema
[db_denydatawriter] Schema
[db_owner] Schema
[db_securityadmin] Schema
[dbo] Schema
[Demo] Schema
[HumanResources] Schema
[Person] Schema
[Production] Schema
[Purchasing] Schema
[Sales] Schema
[Security] Schema
[SQLCop] Schema
[guest] Schema
[INFORMATION_SCHEMA] Schema
[sys] Schema
[HumanResources].[HRResumeSchemaCollection] XML Schema Collection
[Person].[AdditionalContactInfoSchemaCollection] XML Schema Collection
[Person].[IndividualSurveySchemaCollection] XML Schema Collection
[Production].[ManuInstructionsSchemaCollection] XML Schema Collection
[Production].[ProductDescriptionSchemaCollection] XML Schema Collection
[Sales].[StoreSurveySchemaCollection] XML Schema Collection
Total: 320 object(s)

Collapse image Objects that depend on [amy0]


Object name Object type Dep level
[dbo].[SalesManagers] Role 1
Total 1 object(s)

Collapse image SQL


CREATE USER [amy0]
    WITHOUT LOGIN
    WITH DEFAULT_SCHEMA = [dbo]
GO

Collapse image See also


List of users