Post reply

User access

  • November 21, 2006 at 10:49 am

    #174966

    Hi, I'm working with Sql Server 2000 Enterprise, I Have a user that only has access to read two tables but i need to allow this user to create views, not to insert and update in other tables or views.

    How can I do that?.

    Thanks,

  • November 21, 2006 at 11:57 am

    #673283

    In EM, right click on the database where the user needs to be able to create views.  Click on the Permissions tab.  There you can grant the user access the ability to create views.

  • November 21, 2006 at 12:18 pm

    #673289

    Won't that grant access to edit other views too??

  • November 21, 2006 at 1:01 pm

    #673307

    That is possible, but I haven't ever had a request like LMtz.  This is how LMtz can grant the user access to creating views.  Unfortunately, I can't come up with any other alternatives at this time.

  • November 21, 2006 at 1:07 pm

    #673310

    HI, thanks for your replys, It only needs to see his own views.

  • November 21, 2006 at 1:15 pm

    #673312

    Can you setup a backup of the db with only those 2 tables and grant him create view there?

Viewing 6 posts - 1 through 5 (of 5 total)

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