Can't assign a role to a login

[robert_pollard]

When executing:
sp_modifylogin rpollard, "add default role", sa_role

I get:
Server Message: Number 17929, Severity 16
Procedure 'sp_modifylogin', Line 438:
The specified role is not granted to the account -- nothing
changed.
(1 row affected)
(return status = 1)

I tried to find out what the problem is by looking at the
code. It appears to try to look up the group and fails.
This is following an example in the documentation and should
work.

Thanks for your time,

Robert Pollard

[Rob Verschoor]

<Robert Pollard> wrote in message news:405fc04f.2d...@sybase.com...

The 'add default role' option applies only to roles that have already been
granted to the login. Also, it applies only to user-defined roles: the
effect of this option is that the role will be enabled by default when the
login connects to ASE. By default, user-defined roles are left disabled at
login time (in contrast, system-defined roles like 'sa_role' are enabled at
login time).
If you were trying to grant sa_role to your login, just run: 'grant role
sa_role to rpollard'.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:r...@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

[robert_pollard]

> --- Rob Verschoor

>
> Certified Sybase Professional DBA for ASE
> 12.5/12.0/11.5/11.0 and Replication Server 12.5
>
> Author of "Tips, Tricks & Recipes for Sybase ASE" and
> "The Complete Sybase ASE Quick Reference Guide"
> Online orders accepted at http://www.sypron.nl/shop
>
> mailto:r...@YOUR.SPAM.sypron.nl.NOT.FOR.ME
> http://www.sypron.nl
> Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The
> Netherlands
> ----------------------------------------------------------
> ---
>

It helped tremendously. Thanks for your time.

As soon as I get the money I'm going to buy your Tip &
Tricks book. There's not a lot of material for Sybase in
print. I have to get it while the getting's good.

Thanks,

Robert

[Rob Verschoor]

>
> It helped tremendously. Thanks for your time.
>
> As soon as I get the money I'm going to buy your Tip &
> Tricks book. There's not a lot of material for Sybase in
> print. I have to get it while the getting's good.
>
> Thanks,
>
> Robert

A very good idea indeed !

Rob V. ;-)