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 2000 Forums
 SQL Server Administration (2000)
 User does not have permission to perform..

Author  Topic 

pradeep617
Starting Member

3 Posts

Posted - 2006-11-27 : 04:28:10
hi,
i am using Microsoft SQL server 2000 and .Net 2003. my machine OS is Windows NT 2000 professional. I got a databse from other machine and restored that databse in my machine. I tried to run a stored procedure from that restored database through .Net application but i get error saying "User does not have permission to perform this action on this table <tablename>". the current login is a part of administrators group. I added the current login in SQL enterprise manager and gave access to this database. still i get this error. i would like to know how to resolve this.

thanks in advance,
Pradeep

Kristen
Test

22859 Posts

Posted - 2006-11-27 : 04:30:41
Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=75428
Go to Top of Page
   

- Advertisement -