Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002

    Unanswered: Inter Database Security

    I have a stored procedure db1.dbo.sp1
    this Stored Procedure grabs data from another database. Say db2.dbo.tbl1

    If i call the qry1.
    how does the security from db2 come in to play? if at all?

    For example, If I am SQL Server Authenticated, for DB1 but not for DB2 will the SP fail. etc.

  2. #2
    Join Date
    Oct 2001
    Naples, FL
    If you have security to db1 but not db2, and you run it as yourself, it will fail.

    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Mar 2002
    Tnx for the info. I picked up some additional tips and was able to confirm your suggestion on our sql servers over here.

    Is there anyway to use NT Authentication in the first db. Then from within a stored procedure (in the 1st database), access the 2nd database using the sa account?

    I.E. pass a sa login request to the 2nd database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts