-
Object permissions might be a heache
Hello!
I created two differnt objects in a database. Let say user1 is the database object owner.
Now the probelm starts when I use the query analyzer for just selecting the data using sa account(sa is the admin to all db) and when happens is that I cant't read the data using SQL QUERY ANALYZER but if I go to the TBALES through explorer then I can open the table using the same sa account.
Is there anybody explain me why its happening?
Thnaks
-
Object permissions might be a heache (reply)
Try this
select * from db_name.owner.table_name
------------
Viv at 5/8/2002 10:53:19 AM
Hello!
I created two differnt objects in a database. Let say user1 is the database object owner.
Now the probelm starts when I use the query analyzer for just selecting the data using sa account(sa is the admin to all db) and when happens is that I cant't read the data using SQL QUERY ANALYZER but if I go to the TBALES through explorer then I can open the table using the same sa account.
Is there anybody explain me why its happening?
Thnaks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|