Re: Table Security

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 02/24/04

  • Next message: Timo: "Re: troubles adding domain group as database role member" 
    Date: Tue, 24 Feb 2004 15:17:52 +0530

    Hi,

    You can not restrict the table by setting a password, rather give privilege
    of that table only to required users using GRANT command.
    You can also restrict the unauthorized user access of the table by DENY
    command (refer BOL)

    Thanks
    Hari
    MCDBA

    "sharon" <anonymous@discussions.microsoft.com> wrote in message
    news:038b01c3fab7$81a1f560$a501280a@phx.gbl...
    > Hi there,
    > i am wondering is there anyway to use a password to
    > protect a table in a SQL database? If yes, can anyone
    > show me how to do it?
    >
    > it's urgent!
    >
    > thanks
    >
    > sharon

  • Next message: Timo: "Re: troubles adding domain group as database role member"