May 13, 2011 at 2:54 pm
I have done the Bookshop DB all the way through to the end and can not get the last two
codes to work, please help
-- In a Command Prompt
Net User Manager01 /Add
Net User Manager02 /Add
Net User Staff01 /Add
Net User Staff02 /Add
Net User Staff03 /Add
-- Using the Computer Management console, add a group named Managers and
-- make Manager01 and Manager02 members of the Managers group.
Exec sp_GrantLogin @LogiName = 'BUILTIN\Users';
Exec sp_GrantLogin @LogiName = 'SQLServer\Managers';
Exec sp_GrantDBAccess @LogiName = 'BUILTIN\Users', @Name_in_db = 'All Staff';
Exec sp_GrantDBAccess @LogiName = 'SQLServer\Managers';
Exec sp_GrantDBAccess @LogiName = 'SQLServer\Manager01';
Exec sp_GrantDBAccess @LogiName = 'SQLServer\Staff01';
Exec sp_GrantDBAccess @LogiName = 'SQLServer\Staff02';
Grant Select On Authors To Public;
Grant Select On BookAuthors To Public;
Grant Select On BookCondition To Public;
Grant Select On Books To Public;
Grant Select On Customers To Public;
Grant Select On FormOfPayment To Public;
Grant Select, Insert, Update, Delete On Orders To Public;
Grant Select, Insert, Update, Delete On BookOrders To Public;
Grant Select, Insert, Update, Delete On OrderStatus To Public;
Grant Insert, Update, Delete On Authors To [SQLServer\Managers];
Grant Insert, Update, Delete On BookAuthors To [SQLServer\Managers];
Grant Insert, Update, Delete On BookCondition To [SQLServer\Managers];
Grant Insert, Update, Delete On Books To [SQLServer\Managers];
GRANT Insert, Update, Delete On Customers To [SQLServer\Managers];
Grant Insert, Update, Delete On FormOfPayment To [SQLServer\Managers];
Grant Select, Insert, Update, Delete On Employees To [SQLServer\Managers];
Grant Select, Insert, Update, Delete On Positions To [SQLServer\Managers];
-- In a Command Prompt
Net User Manager01 /Add
Net User Manager02 /Add
Net User Staff01 /Add
Net User Staff02 /Add
Net User Staff03 /Add
-- Using the Computer Management console, add a group named Managers and
-- make Manager01 and Manager02 members of the Managers group.
Exec sp_GrantLogin @LogiName = 'BUILTIN\Users';
Exec sp_GrantLogin @LogiName = 'SQLServer\Managers';
Exec sp_GrantDBAccess @LogiName = 'BUILTIN\Users', @Name_in_db = 'All Staff';
Exec sp_GrantDBAccess @LogiName = 'SQLServer\Managers';
Exec sp_GrantDBAccess @LogiName = 'SQLServer\Manager01';
Exec sp_GrantDBAccess @LogiName = 'SQLServer\Staff01';
Exec sp_GrantDBAccess @LogiName = 'SQLServer\Staff02';
Grant Select On Authors To Public;
Grant Select On BookAuthors To Public;
Grant Select On BookCondition To Public;
Grant Select On Books To Public;
Grant Select On Customers To Public;
Grant Select On FormOfPayment To Public;
Grant Select, Insert, Update, Delete On Orders To Public;
Grant Select, Insert, Update, Delete On BookOrders To Public;
Grant Select, Insert, Update, Delete On OrderStatus To Public;
Grant Insert, Update, Delete On Authors To [SQLServer\Managers];
Grant Insert, Update, Delete On BookAuthors To [SQLServer\Managers];
Grant Insert, Update, Delete On BookCondition To [SQLServer\Managers];
Grant Insert, Update, Delete On Books To [SQLServer\Managers];
GRANT Insert, Update, Delete On Customers To [SQLServer\Managers];
Grant Insert, Update, Delete On FormOfPayment To [SQLServer\Managers];
Grant Select, Insert, Update, Delete On Employees To [SQLServer\Managers];
Grant Select, Insert, Update, Delete On Positions To [SQLServer\Managers];
-- In a Command Prompt
Net User Manager01 /Add
Net User Manager02 /Add
Net User Staff01 /Add
Net User Staff02 /Add
Net User Staff03 /Add
-- Using the Computer Management console, add a group named Managers and
-- make Manager01 and Manager02 members of the Managers group.
Exec sp_GrantLogin @LogiName = 'BUILTIN\Users';
Exec sp_GrantLogin @LogiName = 'SQLServer\Managers';
Exec sp_GrantDBAccess @LogiName = 'BUILTIN\Users', @Name_in_db = 'All Staff';
Exec sp_GrantDBAccess @LogiName = 'SQLServer\Managers';
Exec sp_GrantDBAccess @LogiName = 'SQLServer\Manager01';
Exec sp_GrantDBAccess @LogiName = 'SQLServer\Staff01';
Exec sp_GrantDBAccess @LogiName = 'SQLServer\Staff02';
Grant Select On Authors To Public;
Grant Select On BookAuthors To Public;
Grant Select On BookCondition To Public;
Grant Select On Books To Public;
Grant Select On Customers To Public;
Grant Select On FormOfPayment To Public;
Grant Select, Insert, Update, Delete On Orders To Public;
Grant Select, Insert, Update, Delete On BookOrders To Public;
Grant Select, Insert, Update, Delete On OrderStatus To Public;
Grant Insert, Update, Delete On Authors To [SQLServer\Managers];
Grant Insert, Update, Delete On BookAuthors To [SQLServer\Managers];
Grant Insert, Update, Delete On BookCondition To [SQLServer\Managers];
Grant Insert, Update, Delete On Books To [SQLServer\Managers];
GRANT Insert, Update, Delete On Customers To [SQLServer\Managers];
Grant Insert, Update, Delete On FormOfPayment To [SQLServer\Managers];
Grant Select, Insert, Update, Delete On Employees To [SQLServer\Managers];
Grant Select, Insert, Update, Delete On Positions To [SQLServer\Managers];
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'User'.
Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 49
Windows NT user or group 'SQLServer\Managers' not found. Check the name again.
Do code do I use for these two
May 13, 2011 at 3:44 pm
Is the server or domain called SQLServer?
Oh, and as the comment says, these need to be run at the command prompt, not in a SQL query window.
-- In a Command Prompt
Net User Manager01 /Add
Net User Manager02 /Add
Net User Staff01 /Add
Net User Staff02 /Add
Net User Staff03 /Add
-- Using the Computer Management console, add a group named Managers and
-- make Manager01 and Manager02 members of the Managers group.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply