SQL Permissions question - SQL Server 2000

From: jdn (jdn_at_discussions.microsoft.com)
Date: 05/20/05


Date: Fri, 20 May 2005 11:18:24 -0700

There's a server that I need a user to have full admin rights to, except for
one particular database, where I only want them to have read-only rights.

Is there a way to do this?

TIA

jdn



Relevant Pages

  • Re: How do I find I am administrator?
    ... I do not have admin rights to whole server? ... > Based on the output you fell inside the 'db_owner' role in your database. ... > 3.Is package admin is different than server adminn? ...
    (microsoft.public.sqlserver.connect)
  • Re: How do I find I am administrator?
    ... I do not have admin rights to whole server? ... > Based on the output you fell inside the 'db_owner' role in your database. ... > 3.Is package admin is different than server adminn? ...
    (microsoft.public.sqlserver.server)
  • Re: How do I find I am administrator?
    ... I do not have admin rights to whole server? ... > Based on the output you fell inside the 'db_owner' role in your database. ... > 3.Is package admin is different than server adminn? ...
    (microsoft.public.sqlserver.tools)
  • Re: How do I find I am administrator?
    ... I do not have admin rights to whole server? ... > Based on the output you fell inside the 'db_owner' role in your database. ... > 3.Is package admin is different than server adminn? ...
    (microsoft.public.sqlserver.setup)
  • Re: How do I find I am administrator?
    ... I do not have admin rights to whole server? ... > Based on the output you fell inside the 'db_owner' role in your database. ... > 3.Is package admin is different than server adminn? ...
    (microsoft.public.sqlserver.clients)