September 20, 2008 at 12:10 am
In my scenario
There are 10 users of the Database in Sql server 2005.
users staring with FWACDH/XYZ, FWACDH/ABC and so on....
I am using one SP , which is generation one table and uses that table for some manipulation.
Later on in same SP i drop that table.
Now problem is when user logeed into the system using this SSPI authentication.
He is not able to drop a table because i have written simplate
ddl statment to drop that table in that store procedure. like drop table Tablename.
When i saw that table in table list it was something like FWACDH/XYZ.Tablename.
So how should i write drop statment in my storeprocedure so that it drops this table.
Do i need to check who is the user logged in this database and that i have to write drop statment according to that?
Help me out.
September 20, 2008 at 2:27 am
Duplicate post. No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic572937-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply