Re: User ID and Password in the Query

From: Louis Davidson (dr_dontspamme_sql_at_hotmail.com)
Date: 01/07/05 

Date: Fri, 7 Jan 2005 14:11:39 -0600

If this is an ongoing thing, it seems to me to be a breach of security to do
this. Why not grant rights to the user? Of course I don't know your exact
situation, but it does raise a small red flag. 

-- 
----------------------------------------------------------------------------
Louis Davidson - drsql@hotmail.com
SQL Server MVP
Compass Technology Management - www.compass.net
Pro SQL Server 2000 Database Design - 
http://www.apress.com/book/bookDisplay.html?bID=266
Note: Please reply to the newsgroups only unless you are interested in 
consulting services.  All other replies may be ignored :)
"VBB" <VBB@discussions.microsoft.com> wrote in message 
news:59E6ED6F-626F-4CCC-983D-13EE6574AA9F@microsoft.com...
> Hi,
>
> How can I pass the user id and password in a simple SQL statement.
>
> The scenario is, I am logged into a database. I do not have permission on 
> a
> table which is in another database of the same server. I had been provided
> the user id and passoword of a user who has access to that table in other
> database. Without logging into query analyser with his credentials(I had
> logged into Query analyser using my user credentials) I need to query that
> table.
> I believe I can query that table by providing user id, password of the 
> user
> who has access in the sql statement.
>
> Thanks in advance.

Relevant Pages

  • Re: SQL server rename
    ... Execute a update statistics for all tables ... Execute a DBCC CHECKDB on the database and analyze the log ... > I had to rename the server that I am running sql server 2000 on. ... > If I use query analyser I can connect to the database no problem. ...
    (microsoft.public.sqlserver.setup)
  • Re: How to Replicate an SQL Server 2000 Database
    ... If i do this in Query Analyser should i have the DB closed? ... Now regarding Replication, i am brand new to this... ... And then stop and start SQL Server. ... Director of Text Mining and Database Strategy ...
    (microsoft.public.sqlserver.replication)
  • User ID and Password in the Query
    ... How can I pass the user id and password in a simple SQL statement. ... The scenario is, I am logged into a database. ... Without logging into query analyser with his credentials(I had ...
    (microsoft.public.sqlserver.programming)
  • RE: User ID and Password in the Query
    ... > How can I pass the user id and password in a simple SQL statement. ... > table which is in another database of the same server. ... Without logging into query analyser with his credentials(I had ...
    (microsoft.public.sqlserver.programming)
  • Re: checking file existence with sql
    ... wondering why the syntax/standard difference. ... statements(the ones that works with sql server 2k) to "access's standards". ... > there is no quarantee that a SQL Server 2000 sql statement will work the ... > While both SQL Server and Access are database products from Microsoft, ...
    (microsoft.public.sqlserver.programming)
Loading