Removing a user

#1

Hi all

Strange but true: Somewhere in the dark past, a user was set up in our ASA
db (6.0.3.2747) with username = 1, password = 1

I'd like to remove this user altogether with the revoke command. Other
usernames respond fine to this, but 'revoke connect from 1' generates a
syntax error ( no, username 1 is not connected at the time...) This seems
to be true for any numeric username.
I know I can probably log on as 1, change the name, then do the revoke...
but our situation dictates that we need to do the removal without the extra
steps.. any ideas?

Thanks,

BH

#2

BH wrote:

Quote:

Hi all

Strange but true: Somewhere in the dark past, a user was set up in our ASA
db (6.0.3.2747) with username = 1, password = 1

I'd like to remove this user altogether with the revoke command. Other
usernames respond fine to this, but 'revoke connect from 1' generates a
syntax error ( no, username 1 is not connected at the time...) This seems
to be true for any numeric username.
I know I can probably log on as 1, change the name, then do the revoke...
but our situation dictates that we need to do the removal without the extra
steps.. any ideas?

Thanks,

BH

revoke connect from "1"
;

#3

Thanks...all is well.

"Phil" <phil (AT) nospamthanks (DOT) com> wrote

Quote:

BH wrote:

Hi all

Strange but true: Somewhere in the dark past, a user was set up in our
ASA
db (6.0.3.2747) with username = 1, password = 1

I'd like to remove this user altogether with the revoke command. Other
usernames respond fine to this, but 'revoke connect from 1' generates a
syntax error ( no, username 1 is not connected at the time...) This
seems
to be true for any numeric username.
I know I can probably log on as 1, change the name, then do the
revoke...
but our situation dictates that we need to do the removal without the
extra
steps.. any ideas?

Thanks,

BH

revoke connect from "1"
;

#4

User ids are identifiers so try this...

REVOKE CONNECT FROM "1";

Breck

On 15 Dec 2003 12:40:28 -0800, "BH" <bohiggy (AT) yahoo (DOT) com> wrote:

Quote:

Hi all

Strange but true: Somewhere in the dark past, a user was set up in our ASA
db (6.0.3.2747) with username = 1, password = 1

I'd like to remove this user altogether with the revoke command. Other
usernames respond fine to this, but 'revoke connect from 1' generates a
syntax error ( no, username 1 is not connected at the time...) This seems
to be true for any numeric username.
I know I can probably log on as 1, change the name, then do the revoke...
but our situation dictates that we need to do the removal without the extra
steps.. any ideas?

Thanks,

BH

--
bcarter (AT) risingroad (DOT) com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Removing a user

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Removing a user - 12-15-2003 , 02:40 PM

Re: Removing a user - 12-15-2003 , 03:04 PM

Re: Removing a user - 12-15-2003 , 03:09 PM

Re: Removing a user - 12-15-2003 , 03:27 PM