You can add the user to the sysadmin fixed server role.
-Sue
On Fri, 11 Feb 2005 17:22:25 -0500, "gv" <viatorg@musc.edu>
wrote:
>Hi all,
>
>If I want to create Amin user in SQL and give that user all permissions like
>sa login.
>How would I do that without having to go into each database and creating
>roles
>or checking permissions for each task?
>
>thanks
>GV
>
Re: Admin sql login ... > You can add the user to the sysadmin fixed server role.... >>If I want to create Amin user in SQL and give that user all permissions... (microsoft.public.sqlserver.security)
Admin sql login ... If I want to create Amin user in SQL and give that user all permissions like ... sa login.... (microsoft.public.sqlserver.security)
Re: SQL CE Synching Problems ... Have you granted IUSER_ServerName access to your publication within SQL... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ... (microsoft.public.sqlserver.ce)
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.server)
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.server)
