Post reply

how to grant privilege on diagram object

  • January 27, 2003 at 9:09 am

    #158818

    Hi,

    I have created a user with the following permits: public, db_datareader, db_datawriter. Now I'm trying to grant full privileges over the diagrams since the users can't see them, but I haven't found any ways to achieve this. Please help!

    Thanks in advance. Regards,

    M71

  • January 28, 2003 at 12:45 pm

    #447396

    You have to grant exec to all dt_* stored procedures on the database for the user to see the diagrams.

  • February 5, 2003 at 1:51 am

    #448062

    I've tried to follow your advice and used the following cmd:

    GRANT EXECUTE ON dt_* TO developer

    but I get a syntax error on dt_*, do I have to issue this command for every single stored procedure?

    Thanks in advance.

    M71

  • February 5, 2003 at 12:20 pm

    #448107

    Sorry for that, with dt_* I mean all stored procedures that begin with dt_

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

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