Can I GRANT PUBLISH to a group user account

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 Dake
41●1●1●2
accept rate: 0%

edited 04 Aug '10, 20:55

Calvin Allen
1.5k●23●26●38

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

flat view

One Answer:

active answers oldest answers newest answers popular answers

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 Carter
32.5k●540●724●1050
accept rate: 20%

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

(05 Aug '10, 14:26) Volker Barth

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

sa-10 ×119
dbremote ×77
grant ×7
publish ×1

question asked: 04 Aug '10, 15:20

question was seen: 2,071 times

last updated: 05 Aug '10, 11:48

SAP SQL Anywhere

Can I GRANT PUBLISH to a group user account

Follow this question

Related questions