Results 1 to 3 of 3

Thread: SQL Table permission

  1. 05-02-2007, 01:54 PM #1
    Picha Pie
    Picha Pie is offline Registered User
    Join Date
    Dec 2003
    Posts
    181

    SQL Table permission

    User A have full privilege(Select,Update,Delete,Insert) to table ABC. Table ABC have 4 columns: Date,Note_Index,Time,Text. I want to change User A privilege to the table and have him do everything except Delete.

    When I go to the table Permissions then Columns I can only do Select and Update. Where can I change Delete?
    Reply With Quote Reply With Quote
  2. 05-02-2007, 03:23 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    There should be a column for DELETE in EM.

    or try running it from query analyzer

    DENY delete on table1 to user1
    Reply With Quote Reply With Quote
  3. 05-02-2007, 03:51 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    No, you can't deny delete on columns.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules