Post reply

Application Role not showing

  • September 29, 2005 at 10:09 am

    #89177

    I created an application role.  I see it in Enterpise Manager but when i try

    use fae

    exec sp_helpuser 'faelogin'

    I get an error message: "The name supplied (FAELogin) is not a user, role, or aliased login."

    I've tried using

    exec sp_helpuser faelogin

    wihout the quote marks but it doesn't work either.

  • September 29, 2005 at 10:30 am

    #594098

    Use sp_helprole

    application role is a database role, not a user

  • September 29, 2005 at 10:46 am

    #594107

    My book doesn't have sp_helprole.

    It says: "

    sp_helpuser [[@name_in_db =] 'username']

    Here, username is optional and is either a username or role name.

    If you don't specify a username, a report of all users and roles is produced.  Otherwise you get a report for a specific user or role."

    This apparently is not true. It doesn't work. When username is not specified it only shows the users not any roles. sp_helprole does work.  sp_helprole lists all the roles.\

    Thanks!

    I have one more question.

    When i try to encrypt the password for the role i get an error again.

    use fae

    exec sp_addapprole 'faelogin', 'fake_pwd'

    go

    exec sp_setapprole 'faelogin', {encrypt N 'fake_pwd'}, 'odbc'

    Error:

    [Microsoft] [ODBC SQL Server Driver] Syntax error or access violation

  • September 30, 2005 at 7:07 am

    #594312

    I supposed you were using SQL 2k. But It seems you are not.

     

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

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