Post reply

Granting Object Permissions on Tables

  • September 29, 2005 at 2:28 pm

    #87854

    I have not created all my stored procedures yet, so i'm still using queries.

    I want to grant my approle object permissions

    grant select, insert, update, references on employees to faelogin

    I have 15 tables! Do i have to list all 15? There isn't a word called ALL!

  • September 30, 2005 at 2:11 am

    #594267

    Hi,

    You are right, you need to list out all tables.

    But why don't you use the standard role db_datawriter? This role has got the same permissions as you want. It also allows delete.

    Regards,

    Geert

  • October 4, 2005 at 3:39 pm

    #595018

    and don't forget db_datareader.

  • October 5, 2005 at 9:00 am

    #595153

    Well, it is temporary even though i don't want delete. 

    Can you assign the permissions of one role to another role?

     

    Thanks guys!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply