powerfull user

From: Usman (jathol_at_hotmail.com)
Date: 05/26/03 

Date: Mon, 26 May 2003 14:26:20 +0500

hi
how can i create a powerfull user.. who can do any thing sa can do...
create databases, etc..
but cant change sa password

what rights should i give him

system admin ??

please help..

what are the maximum rights.. but cant change sa password..

thanks
Usman

Relevant Pages

  • RE: Users on a DB are dropped without any intervention
    ... This posting is provided “AS IS” with no warranties, and confers no rights. ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ... | rights in a couple of the databases that they had rights ...
    (microsoft.public.sqlserver.security)
  • Re: Stored Proc rights and joinning to another database
    ... If the databases and tables has the same owner, ... As of sp3, ... I have a little problem with one of my Stored Proc. ... rights to my users on tables but I give execute rights on my Stored ...
    (microsoft.public.sqlserver.server)
  • Re: Revoking public permissions
    ... We have many databases with all rights to user tables, views, stored ... (I have never tried to revoke public rights to the ... the public role in the system databases. ...
    (microsoft.public.sqlserver.security)
  • Lost User rights / permissions
    ... I have 2 login accounts that infrequently lose all of ... their permissions and rights to databases and stored ... has read access to 2 databases, ... rights against a stored procedure. ...
    (microsoft.public.sqlserver.security)
  • Re: Lost User rights / permissions
    ... No databases have been restored when this happens. ... just one day the user has access with specific rights to ... >SQL Server FAQ, articles, code samples, interview ... >rights against a stored procedure. ...
    (microsoft.public.sqlserver.security)