Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Manipulating Tables Expand / Collapse
Can i login another user when i was actually using SA account? is it possible in query?
Poll ResultsVotes
Can i login another user when i was actually using SA account? is it possible in query?
0%
0
Member Votes: 0, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Sunday, December 7, 2008 8:28 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, September 9, 2012 9:12 PM
Points: 8, Visits: 37
I need help from our Genius DBA's!

Can i login another user when i was actually using SA account? is it possible in query?

I was thinking like this:

as I was logged on as SA and I created a table named dbo.Product, then I created a new user named User1 with the same access as I do, then I will shift to that user and create a table named User1.Product. There I have created table with the same name with different schema. But what I'm trying to reach is when every time I add a new record in Product table only the logged on user will add record to which I have created table.

Scenario:
Logged on user: User1, added new record in Product table values 'U-Prod1', and 'U-Prod1'

then user: SA, added new record in Product table values 'SA-Prod1', and 'SA-Prod1'

when User1 add record it will basically saved to User.Product table and SA will be saved in dbo.Product table, so right there I could get my own clustered tables based on the logged on member, only that I could only create table maximum to SQL's table limit. but wont be a problem.

I just want to know how will I be able to do that query.


_____________________________________________
ToM™ (Possibility will come out of nothing)
Post #615337
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse