Manipulating Tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Strategies » Manipulating Tables

Manipulating Tables

Rate Topic

Display Mode

Topic Options

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

Poll Results

Votes

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

Member Votes: 0, Anonymous Votes: 0. You don't have permission to vote within this poll.

Author

Message

Tom.Bauto

Posted Sunday, December 07, 2008 8:28 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, September 09, 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 »

Permissions