Post reply

grant to user fails

  • August 6, 2010 at 7:06 am

    #387517

    Hi all,

    I need to grant permission to a user, but its failing. The user is UCX\user1 (windows login)

    grant alter any application role from UCX\user1

    Msg 102, Level 15, State 1, Line 2

    Incorrect syntax near '\'.

    grant alter any application role from user1

    Msg 15151, Level 16, State 1, Line 2

    Cannot find the user 'user1', because it does not exist or you do not have permission.

    But when I try for other users in the database without \, it works. ANy help please

    Thanks

  • August 6, 2010 at 7:08 am

    #1203489

    Sorry, I found the problem. I need to use [UCX\user1]

  • August 6, 2010 at 7:36 am

    #1203509

    When I run drop application role testrole, I get

    Msg 15284, Level 16, State 1, Line 1

    The database principal has granted or denied permissions to objects in the database and cannot be dropped.

    I ran select * from sys.database_permissions where grantor_principal_id = user_id ('testrole');

    4DATABASE_PRINCIPAL1501415AL ALTERGGRANT

    4DATABASE_PRINCIPAL1501415CL CONTROLGGRANT

    4DATABASE_PRINCIPAL1501415VW VIEW DEFINITIONGGRANT

    But not sure how I can revoke, is there another way to find this out??

    Thanks much

  • May 19, 2011 at 6:37 pm

    #1327442

    did you ever get an answer?

  • December 19, 2011 at 6:43 am

    #1423079

    ..... deleted ....

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

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