Post reply

create user with very few privileges.

  • February 24, 2010 at 12:31 pm

    #156712

    hello,

    I am curious to know if there is anyway by which we can create a user, which can select and create views.This user can perform these operations only in his own schema.This user can not perform any other DML,DDL statements.No other privileges provided.

    Thank you.

  • February 24, 2010 at 2:51 pm

    #1124617

    I see a bit of a problem. He probably can't create any views on any tables he doesn't own.

    Why don't you tell me what you are trying to accomplish instead of your solution.

    CEWII

  • February 24, 2010 at 3:06 pm

    #1124627

    you should assign as db_owner of that database

  • February 24, 2010 at 3:12 pm

    #1124630

    MAK-1128556 (2/24/2010)

    you should assign as db_owner of that database

    Hmmm I think this is not a solution!!!!!!! :hehe::w00t::-P:-D:-):-P;-):w00t::cool::hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • February 24, 2010 at 4:21 pm

    #1124665

    Something like the following would give the user SCTest SELECT permissions on a schema called 'UserSch' to the user SCTest. The second statement grants the user create view permissions.

    GRANT SELECT ON SCHEMA::[UserSch] TO [SCTest]

    GRANT CREATE VIEW TO [SCTest]

    Gethyn Elliswww.gethynellis.com

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

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