Re: Give full control on db by T-sql statement

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 05/05/05 

Date: Thu, 5 May 2005 13:33:38 +0200

Please do NOT mulitpost, answered in programming.

Jens SUessmeyer. 

---
http://www.sqlserver2005.de
---
"Venkat" <tammana@inooga.com> schrieb im Newsbeitrag 
news:O9$kXTWUFHA.584@TK2MSFTNGP15.phx.gbl...
> Can any one give me an example to give admin role (Full access) on a 
> database to a Role in the sql server database using T-sql statements. I am 
> trying to create roles and users in sql server using t-sql statements. 
> when i create a user it will be created with a permission to login to that 
> db. but no permission to select any of the table data. I need to create a 
> admin user which has full control on db and the remaining users will get 
> permission on specific tables.
>
>
> --
> Srikanth
>

Relevant Pages

  • Re: permission to run application on server
    ... logged in as admin but not as domain user, how to setup permission to allow a user to run the software without making him admin? ... then setting permissions on SQL Server might be your first line of attack. ...
    (microsoft.public.windows.server.sbs)
  • RE: Win NT Permission question ?
    ... regarding my posting, yea, i had it messed up a bit, with admin you can ... Subject: Win NT Permission question? ... Gain the in-demand ... skills of a certified computer examiner, learn to recover trace data ...
    (Security-Basics)
  • Re: Clustering and SA Role
    ... It helps if your Domain/Enterprise Administrators, Server Administrators, ... > I guess the issue is that in SQL2000 one could remove local admin group ... > legitimately getting into SQL Server. ... Trust for sure simplifies management in many ...
    (microsoft.public.sqlserver.clustering)
  • Re: Account to Run SQL under?
    ... you use AD Global Groups to grant the SQL Server DBAs administrative access, ... How to impede Windows NT administrators from administering a clustered ... with great power comes great responsibility. ... If you do not want local administrators to have system admin access rights then all you need to so is restrict the BUILTIN\Administrators rights. ...
    (microsoft.public.sqlserver.server)
  • Re: You dont have permission to read
    ... then you are opening the secured database using a secure workgroup. ... generally the Admin user does not have permission to do ... > permission to read - object name". ...
    (microsoft.public.access.security)