Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access database without password and username
Message
From
18/10/2006 10:19:50
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
18/10/2006 10:03:29
General information
Forum:
Microsoft SQL Server
Category:
Security
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01162920
Message ID:
01162941
Views:
14
>but if I'm connect with one user , I need say store procedure that he execute the transacs with other different user and password, how can I do.
>Something like "execute as" of sql2005.

You can't do that directly like you showed. Execute is granted to public role. Anyone can execute. However if an SP is not allowed to some role SP doesn't continue.
You should give permission. Check grant, setuser etc. Insetad of username/pwd trusted_connection might be your ticket. You can't grant cross database permissions (and if you have permission to grant you don't need to grant in the first place).
Connect as the user with needed permissions available from the start.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform