The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Ok, I know I can but is there a reason I should not? SA 10.0.1: DBA has been changed to a group account. In Sybase Central if I go to the SQL Remote tab of the database properties to set the publisher the only accounts listed are user accounts. In ISQL I can grant publish authority to DBA without any problem. Is there a valid reason why Sybase Central would not let me do this?

asked 04 Aug '10, 15:20

Todd%20Dake's gravatar image

Todd Dake
41112
accept rate: 0%

edited 04 Aug '10, 20:55

Calvin%20Allen's gravatar image

Calvin Allen
1.5k232638

1

In the left pane, right-mouse-click on DBA. It will let you "Change to user". If you do that, then right-mouse-click AGAIN, it offers you four choices. ...if you can figure out the logic behind all of that, you are smarter than I :)...

(04 Aug '10, 18:37) Breck Carter

We need DBA to remain a group, however.

(04 Aug '10, 23:46) Calvin Allen

Well, yes, of course... and there should be no conflict IMO, just in Sybase Central's mind :) ...so use dbisql.

(05 Aug '10, 11:18) Breck Carter

This may be a flaw in Sybase Central that extends to Version 12: Sybase Central shows each user id as having a single "Type" value: Group OR Publisher OR User, when in fact the SYSUSERAUTHORITY table shows each user id can have multiple "auth" values:

GRANT GROUP TO DBA;
GRANT PUBLISH TO DBA;

SELECT SYSUSERAUTHORITY.* FROM SYSUSERAUTHORITY INNER JOIN SYSUSERPERM ON SYSUSERPERM.user_id = SYSUSERAUTHORITY.user_id WHERE SYSUSERPERM.user_name = 'DBA';

user_id,auth 1,'DBA' 1,'RESOURCE' 1,'GROUP' 1,'PUBLISH'

In this case, Sybase Central says the type is "Publisher", but if you do right-mouse-Revoke-Publisher, it shows the type as "Group".

To paraphrase Animal Farm, in the mind of Sybase Central some types are more equal than others :)

permanent link

answered 05 Aug '10, 11:48

Breck%20Carter's gravatar image

Breck Carter
26.6k418575824
accept rate: 21%

1

...and command line/SQL statement freaks are different from GUI guys:)

(05 Aug '10, 14:26) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×113
×39
×5
×1

question asked: 04 Aug '10, 15:20

question was seen: 951 times

last updated: 05 Aug '10, 11:48