Users logging in as the same user..

HI there..

I have a problem with ASE12.0 .. I have created 10 users on the database 
and granted everybody permissions and all.. However, it seems everybody, no 
matter who logs in, logs in as the same user..

For eg... I have user logins John, Alex, Alan, Steve......etc etc
And i created a user group for all of them (eg developers..)

However, when they log on to isql, anything that they do will be under 
John, no matter if it is logins John, Alex, Steve... or etc etc..

If i do a sp_who.. all the connections will be listed as John.
If they create tables, all table created will be owned by JOhn
If they create stored procs.. all owners are John..

and you get my drift here..

Can anyone help me here? 

Cheers
Robbie

Did you do:

sp_adduser Steve, Steve, developer

or did you:

sp_addalias Steve, John?

The latter would result in the situation that you are describing.  (If so,
then do sp_dropalias Steve, etc. and then do sp_adduser ...)


<fowler> wrote in message
news:[email protected]
> HI there..
>
> I have a problem with ASE12.0 .. I have created 10 users on the database
> and granted everybody permissions and all.. However, it seems everybody,
no
> matter who logs in, logs in as the same user..
>
> For eg... I have user logins John, Alex, Alan, Steve......etc etc
> And i created a user group for all of them (eg developers..)
>
> However, when they log on to isql, anything that they do will be under
> John, no matter if it is logins John, Alex, Steve... or etc etc..
>
> If i do a sp_who.. all the connections will be listed as John.
> If they create tables, all table created will be owned by JOhn
> If they create stored procs.. all owners are John..
>
> and you get my drift here..
>
> Can anyone help me here?
>
> Cheers
> Robbie

Hi there..

Nope, actually i used Sybase Central to add the users.. And i am sure that 
i didnt create an alias.

anybody?

Robbie..

run sp_helpuser in the database where you are having problem and post the
output for help

Babu

<Fowler> wrote in message
news:[email protected]
> Hi there..
>
> Nope, actually i used Sybase Central to add the users.. And i am sure that
> i didnt create an alias.
>
> anybody?
>
> Robbie..

Hi there..

Heres the output of sp_helpuser 





Users_name        ID_in_db Group_name        Login_name
 ----------------- -------- ----------------- -----------------
 alex                     4 dev               alex
 craig                    6 dev               craig
 dbo                      1 public            sa
 susan                    8 public            susan
 kevin                   11 dev               kevin
 lisa                     3 dev               lisa
 mei                      7 dev               mei
 jerzy                    9 dev               jerzy
 robbie                  10 public            robbie
 suzy                     5 dev               suzy
(return status = 0)


basically, if anybody in the dev group logins, they will login as lisa.. 
Any tables, stored procs they create will be created under lisa.. Also when 
they are logged on, and i do a sp_who, it will look as if multiple lisa's 
are logged on...

Anybody can help me here?

Cheers
Robbie

When the users login, do they specify a user with '-U<login>' or are they
defaulting to some environment variable?

Fowler wrote:

> Hi there..
>
> Heres the output of sp_helpuser
>
> Users_name        ID_in_db Group_name        Login_name
>  ----------------- -------- ----------------- -----------------
>  alex                     4 dev               alex
>  craig                    6 dev               craig
>  dbo                      1 public            sa
>  susan                    8 public            susan
>  kevin                   11 dev               kevin
>  lisa                     3 dev               lisa
>  mei                      7 dev               mei
>  jerzy                    9 dev               jerzy
>  robbie                  10 public            robbie
>  suzy                     5 dev               suzy
> (return status = 0)
>
> basically, if anybody in the dev group logins, they will login as lisa..
> Any tables, stored procs they create will be created under lisa.. Also when
> they are logged on, and i do a sp_who, it will look as if multiple lisa's
> are logged on...
>
> Anybody can help me here?
>
> Cheers
> Robbie