Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 table information when there is no previlages

Author  Topic 

subbi39
Starting Member

11 Posts

Posted - 2009-05-02 : 23:06:18
Dear all,
I got a small doubt on table level,as if there in no user permissions on a perticular table in a database and if i need to retrieve data from that object how it is possible...

please help me about this.

thankyou in advance...

Vinnie881
Master Smack Fu Yak Hacker

1231 Posts

Posted - 2009-05-03 : 00:16:12
Tables will inherit the permissions from the database if there is nothing is set at the table level. Log on with an Administrative(sa) account and try again. You can change the permissions with that account if need be.


Success is 10% Intelligence, 70% Determination, and 22% Stupidity.
\_/ _/ _/\_/ _/\_/ _/ _/- 881
Go to Top of Page
   

- Advertisement -