March 6, 2008 at 10:57 am
so here's a question....
I have sysadmin everywhere so cannot see how to test this.......
A user accesses SQL using windows authentication as a member of a sw group, their individual id is not explicitly defined to SQL. They are not sysadmin , neither are they dbo in any database or a member of db_owner role.
They have create table rights in a database, my question is, if they create a table without qualifying it, who is assigned as owner of the table and can other members of the same sw group access this table.
I presume the individual windows id is assigned as owner and the answer to part 2 is no, but I cannot test this and am not 100% sure
---------------------------------------------------------------------
March 6, 2008 at 1:50 pm
They will create tables with ownership under their own accounts. One user cannot access to a table created by another user. He is only the owner of the table he creates by himself.
March 10, 2008 at 11:11 am
Mr. Oracle, thanks for the input, it was as you said.
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply