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
25.7k428592852
accept rate: 20%

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:

×114
×43
×5
×1

question asked: 04 Aug '10, 15:20

question was seen: 992 times

last updated: 05 Aug '10, 11:48