Grant Permission

I have one doubt.
I have created one user "Testuser" and it is asssined to public role.
The created user does not have create table permission by default. What
i did was i have granted create table permission to "Testuser" from my
sa login. I have created one table called "permission_test" using
"Testuser". Now "Testuser" become the owner of this table.
i have tried access the table from the Testuser. I can do it.
Now the problem is that if i have tried access the table from my sa
login. i.e
select * from "permission_test" I got the error saying that "Invalid
object name 'permission_test'"
Then i have executed the follwing statment from my testuser
grant select on permission_test to dbo
after this i am getting follwing errors "Invalid object name
'permission_test'"
What should i do to avoid this problem?
My doubt is that,if the owner is different from the DBO, then DBO could
not have any acess to other owners objects?
RegardsUse the 4-part name server.db.owner.object
joe.
"Praveen" <apveen@.gmail.com> wrote in message
news:1127306421.920830.60330@.g14g2000cwa.googlegroups.com...
>I have one doubt.
> I have created one user "Testuser" and it is asssined to public role.
> The created user does not have create table permission by default. What
> i did was i have granted create table permission to "Testuser" from my
> sa login. I have created one table called "permission_test" using
> "Testuser". Now "Testuser" become the owner of this table.
>
> i have tried access the table from the Testuser. I can do it.
>
> Now the problem is that if i have tried access the table from my sa
> login. i.e
> select * from "permission_test" I got the error saying that "Invalid
> object name 'permission_test'"
>
> Then i have executed the follwing statment from my testuser
>
> grant select on permission_test to dbo
>
> after this i am getting follwing errors "Invalid object name
> 'permission_test'"
>
> What should i do to avoid this problem?
>
> My doubt is that,if the owner is different from the DBO, then DBO could
> not have any acess to other owners objects?
>
> Regards
>