SQL FOR BUSINESS
... Problem#2 You are a database developer for your company. A SQL Server 2000 computer named SQL2K is used to store customer information for your company and is a member of your company's Windows 2000 domain named SYSCOM. Your company hires a new customer service manager named Monica. You create a user account named Monica in SYSCOM. You create a Windows authenticated login for Monica on SQL2K. Permissions on the Customers table of the Northwind database are configured as shown: Monica's user account has already been added to the database. Monica needs permission to view, add, edit, and remove information in the Customers table. You must accomplish this with the least amount of effort, while minimizing the impact on the administration of the security structure. Which Transact-SQL statements should you execute? EXEC sp_adduser Monica, ‘SYSCOM’ EXEC sp_addlogin Moncia, ‘SQL2K’ GRANT ALL ON Customers TO ‘Monica’ Problem#3 You are a member of a database development team for a telecommunications company. Another developer on the team, Marc, has created a table named Customers in the Corporate database. Because the table contains confidential information, he has granted SELECT permissions on the table only to the other members of your team. You are developing an application that will allow employees in the marketing department to view some of the information in the Customers table. These employees are all members of the Marketing database role. To support this application, you create a view named vwCustomers on the Customers table. After creating the view, you grant SELECT...