Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Manipulating Tables, and trying to maximize its purpose? Expand / Collapse
Posted Sunday, December 7, 2008 8:30 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.

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 #615339
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse