var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Create tables under different users.
I know this may sound stupid but I really can't figure out how to do it. I just keep going around in cricles.
I need to create six table under three different users. so I would have users1 owning tableA and tableB. Then I would have users2 owning another copy of tableA and tableB. same for users3.
But I just can't find a way of doing it, I am using enterprise manager. Please help, Ed
It's painful using Enterprise Mangler. Can you use Query Analyzer?
Yep, I can use the Query Analyses can you tell me how? Ed
CREATE TABLE user1.TableA(Col1 int, ect...
CREATE TABLE user1.TableB(Col1 int, ect...
CREATE TABLE user2.TableA(Col1 int, ect...
CREATE TABLE user2.TableB(Col1 int, ect...
CREATE TABLE user3.TableA(Col1 int, ect...
CREATE TABLE user3.TableB(Col1 int, ect...
Of course, the unasked question is WHETHER you should do this...