Grant Privileges

From: Arne (Arne_at_discussions.microsoft.com)
Date: 02/15/05

  • Next message: Neil W.: "extended stored procedure catch 22" 
    Date: Tue, 15 Feb 2005 14:47:03 -0800

    I am trying to give limited privileges to a login account on a table, but it
    doesn't seem to work. I have a link table in Access 97. Some columns are
    supposed to be read only and some columns are supposed to be read-only.
    I use the script below

    revoke all privileges on stores to shipdirect1
    grant update on stores(creditlimit) to shipdirect1

    What am I doing wrong?

  • Next message: Neil W.: "extended stored procedure catch 22"