ASE Database forum - executing "select name from master..sysdatabases" as root

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

executing "select name from master..sysdatabases" as root

Vikrant

2005-10-27, 8:21 am

Is it possible to login as root and then execute
executing "select name from master..sysdatabases"
i.e. w/o login as the database user?

Any workarounds to login as root and run that sql?

Thanks,
-Vikrant

Bret Halford

2005-10-27, 8:21 am

It is not possible to log in without logging in.

To login, you must login using a login name registered in syslogins.

-bret

Vikrant wrote:

> Is it possible to login as root and then execute
> executing "select name from master..sysdatabases"
> i.e. w/o login as the database user?
>
> Any workarounds to login as root and run that sql?
>
> Thanks,
> -Vikrant

Sponsored Links