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?

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