Re: Enterprise Manager list databases

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 12:08:11 +0100

> Just out of curiosity, is it possible to get the database list from ASP?

You can get a list of databases from any programming language from which you can execute SQL
statements:

SELECT CATALOG_NAME FROM INFORMATION_SCHEMA.SCHEMATA
or
SELECT name FROM sysdatabases 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@borko.co.co> wrote in message news:ctd2p1$4j2$1@ls219.htnet.hr...
> Hi,
> Provider (that I am stuck with) doesn't allow me to use Enterprise Manager because of 
> privacy/business secret ... they don't want me to be able to see what users are on the server 
> (database names)
>
> Just out of curiosity, is it possible to get the database list from ASP?
>
> Thanks,
> Borko
>
>
> "Anthony Thomas" <ALThomas@kc.rr.com> wrote in message 
> news:O9VSm6GBFHA.2428@TK2MSFTNGP14.phx.gbl...
>> Even if you "hacked" the system sp, the next hotfix or service pack release
>> would overwrite any work you had done.  Moreoer, the
>> INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
>> user.
>>
>> This is the nature of a DBMS, to announce its existence and the catalogues
>> it make available.  It is up to the DBA to secure those systems, not to hide
>> them.
>>
>> Out of curiosity, why the need to conceal the names?
>>
>> Sincerely,
>>
>>
>> Anthony Thomas
>>
>>
>> -- 
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
>> message news:eTK$umGBFHA.3472@TK2MSFTNGP14.phx.gbl...
>> Not any supported way. The only way I know of would be to hack the stored
>> procedure that EM uses to
>> retrieve the database list. This is not supported and done at your own risk.
>> I don't recommend it.
>> Possibly, you find such hack if you search the newsgroup archives.
>>
>> -- 
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>>
>> "borko" <borko@borko.co.co> wrote in message
>> news:ctakq8$c0n$1@ls219.htnet.hr...
>>> Hi everyone,
>>>
>>> Is there a possibility to block SQL user using Enterprise Manager from
>> listing other databases on
>>> SQL server?
>>>
>>> Every user can see the list of databases but can change only his database.
>> Is there a way to set
>>> it up just his own and nothing else.
>>>
>>> Suggestions, links, ... appreciated
>>>
>>> Thanks,
>>> Borko
>>>
>>
>>
>
>

Relevant Pages

  • Re: Are Frontpage passwords secure?
    ... These access a sql server ... > database which has credit cards. ... How does your asp get the credentials for presentation to SQL?? ... If you are using the DB for credit card info, ...
    (microsoft.public.security)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: ASP Help Needed
    ... Derive the difference, again, using datediff() ... dont touch the database (best practice - if you did a PORPER analisys ... > I need some help with the ASP. ... > I am using MS SQL server 2000 as database ...
    (microsoft.public.inetserver.asp.components)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
Loading