Results 1 to 2 of 2

Thread: sybase_ts_role

  1. #1
    Join Date
    Jun 2002
    Posts
    16

    Unanswered: sybase_ts_role

    Hello,
    I have a program which does a dbreadpage. This program connects to a ASE 11.9.2 server and retrieves and then dumps the page requested. I am trying to run this on Solaris 5.7 and on HP11. The user 'sa' on the HP11 and solaris ASE 11.9.2 instances do not have sybase_ts_role granted to sa. The program works fine on solaris but does not on HP11. On HP11 it errors out saying 'sybase_ts_role' needs to be granted.
    Anybody got any ideas why this is happening.

    raj.

  2. #2
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159
    Log on as an sso_role enabled login, by default sa has this.

    grant role sybase_ts_role to sa
    go
    set role sybase_ts_role on
    go

    Enables sybase_ts_role temporarilly.

    grant role sybase_ts_role to sa
    go
    sp_modifylogin sa, 'add default role', 'sybase_ts_role'
    go

    Enables this by default for all future sa logins.

Posting Permissions

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