I've created a web service endpoint on SQL Server 2005. But I failed trying to give access to a database role. I can only grant access to SQL Server users.
Re: Controlling access with custom groups ... Adding a fixed database role to a user-defined role is not permitted. ... Columnist, SQL Server Professional... db_datareader, through Enterprise Manager.... then grant access to the role. ... (microsoft.public.sqlserver.security)
Re: prevent developers writting to our SQL DB ? ... Then only grant access to the procs and views and deny access directly to ... Abstract this through the use of a database role.... Looking for a SQL Server replication book?... How can we employ this in a VB and SQL environment when users need ... (microsoft.public.sqlserver.server)
Re: Windows authentication failed on SQL2000 +NT4 ... Thanks for your reply Dejan,... followed the instructions from the SQL Server Book.... > You have to grant access to SQL Server to Win users and groups. ... (microsoft.public.sqlserver.security)
Re: WSS 2 to WSS 3 migration error ... Thanks for your response Peter.... would I grant access to the user? ...SQL server or in this case Windows internal DB. ... It is possible that your account... (microsoft.public.sharepoint.windowsservices)
Re: Database Access ... > Do you create the group in SQL Server on the NT Domain? ...Sort of. ... You create the group in the NT domain, then grant access to the ... This email account is my spam trap so I ... (microsoft.public.scripting.jscript)