Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2008
    Posts
    10

    Unanswered: Issues with ‘set proxy’ command

    We’re having problems with using the ‘set proxy’ command in sybase.



    I have it working on one development database and one production database.



    The User: PIA_PT_IIS_USER is setup with sso and is a user of master and dbo of its default database jria3



    sp_displayLogin:

    Suid: 2605

    Loginame: PIA_PT_IIS_USER

    Fullname: PT IIS USER

    Default Database: jria3

    Default Language: us_english

    Auto Login Script:

    Configured Authorization:

    sso_role (default ON)

    Locked: NO

    Date of Last Password Change: Feb 2 2012 12:00AM

    Password expiration interval: 31

    Password expired: NO

    Minimum password length: 6

    Maximum failed logins: 0

    Current failed login attempts:



    This users works fine and I am able to use the ‘set proxy’ command.



    But I am trying to set-up the exact same setup in another development server.



    This time the users name is DEV_IIS_USER



    sp_displayLogin:

    Suid: 794

    Loginame: DEV_IIS_USER

    Fullname: Dev IIS User

    Default Database: D_DB13

    Default Language: us_english

    Auto Login Script:

    Configured Authorization:

    sso_role (default ON)

    Locked: NO

    Date of Last Password Change: Jul 14 2010 2:26PM

    Password expiration interval: 0

    Password expired: NO

    Minimum password length: 6

    Maximum failed logins: 0

    Current failed login attempts:



    But when I try to execute the ‘set proxy’ command I get the following error



    1 1 0 Execution Number (10331) Severity (14) State (1) Server (dev_test) SET SESSION AUTHORIZATION permission denied, database master, owner dbo





    Have you any ideas to why I am getting this error? Is there an higher level setting I need to enable on the server?

  2. #2
    Join Date
    Nov 2002
    Posts
    94
    you need to grant 'set proxy' to a role created by sso. Check your PIA_PT_IIS_USER login belongs to which role and its perms. apply same to DEV_IIS_USER

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •