permissions in SQL Server 2000

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)

permissions in SQL Server 2000

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-07-20 : 12:54:37

paul writes "We have just upgraded to SQL Server 2000 from access, Ive imported the data from access. I am now getting an error message from my vb6 program which is "SELECT Permission denied on object 'Orders'". I Figure I havent set the permissions up properly in SQL server (Although I can connect and retrieve infomation from the n/wind database) Please help"

Kristen
Test

22859 Posts

Posted - 2004-07-20 : 13:00:49

This is a cheap&dirty solution:

Enterprise Manager
security
Logins
Right Click the user (right window)
Properties
[Database Access] tab
Click to highlight the database (the PERMIT column should already be selected)
In the bottom window (roles) select
db_datareader & db_datawriter

This will effectively give permission to the user to SELECT & INSERT/UPDATE/DELETE **any** table in the database.

You probably ought to review security so you only grant rights where needed, but this will get you going

Krsiten

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources