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? |
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; 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 :) |
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 :)...
We need DBA to remain a group, however.
Well, yes, of course... and there should be no conflict IMO, just in Sybase Central's mind :) ...so use dbisql.