How to connect to SQL server database from Oracle 9ias Application Server (9.0.3) & Test & Verify the Connection. Is it posible.I've never done it...only worked with 8i...
didn't see too much connectivity stuff though...
You might try the Oracle (http://www.dbforums.com/f4) Forum though...
Showing posts with label verify. Show all posts
Showing posts with label verify. Show all posts
Wednesday, March 28, 2012
Sunday, February 19, 2012
How to check/verify SQL login Credential
Hi,
I am making a module to backup SQL Db from webpage. I impersonate asp.net user to a given Windows Account and need to verify that account has required permission in SQL Server.
I don't know how to verify the windows account credential for SQL Server login.
Now what I am doing is to run SQL query against database to select row from some table, if it is successful, the user is valid SQL login. But I know it's not the way.
Any idea?
Thanks,
Why don't you just try to login and do the backup and if it fails you know you don't have permission
Subscribe to:
Posts (Atom)