RE: basic question on permissions..

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 17:34:40 GMT

Can you allow them to Term Serv into another machine other than SQL?

Running queries and managing the database doesn't equate to having to be a
sysadmin.
What exactly do they need to do?
Perhaps all they need is DBO access to their database, not Sysadmin access
to the entire server.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • Re: db_denydatawriter
    ... perhaps this also gives read write access on the database to this user? ... Resrictive permissions overrides in its own level. ... However, if she has sysadmin right, then she'll be able to modify that data. ... Is it possible she has some admin rights which override DenyWriter (though ...
    (microsoft.public.sqlserver.security)
  • Re: Restricting Access priviledge on SQL2000
    ... The "Application-Administrators" are neither members of sysadmin nor ... their respective database, but as well as to the defaults database (master, ... then make them members of the db_owner role in that database. ... then add the real SQL Server admins specifically to the ...
    (microsoft.public.sqlserver.security)
  • Re: Disable Sysadmin to view metadata in SQL2005
    ... given the fact that they have sysadmin rights to that box? ... If the permissions are not granular enough, ... I think it's View Any Database / View Server State/ View ... the metadata? ...
    (microsoft.public.sqlserver.security)
  • Re: New install of Windows 2003 EE sp1 and Sql Server 2000 sp3 full text problem
    ... i'm the database guy and I didn't alter it. ... default db is master and it belongs to the ... > database with sysadmin rights? ... > exec sp_defaultdb N'NT Authority\System', ...
    (microsoft.public.sqlserver.fulltext)
  • Re: ISV Using SQL Authentication - a login concern
    ... Senior Database Administrator ... > -create a new custom login called something like MyAppUser ... Backup requires dbo or sysadmin membership ... Maybe using NT authentication to an administrator account on ...
    (microsoft.public.sqlserver.security)