Manipulating Tables, and trying to maximize its purpose?

  • 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.

    _____________________________________________
    [font="Verdana"]ToM™[/font] (Possibility will come out of nothing)

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply