Can I GRANT PUBLISH to a group user account

[Former Member]

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?

[Breck_Carter]

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 :)...

[Former Member]

We need DBA to remain a group, however.

[Breck_Carter]

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

[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 🙂

[VolkerBarth]

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