New to SQL server. I have created a database in SQL7 and have created a
table in the database ICFPM. Its really basic, just two fields. I have
created a new login to the database, and have made the user a member of
everything. I set the database up as a system DSN and have tested the
connection with the user name and password created and it works.

I am using Access 2000 to try and select the records from the table that I
created, but I am getting a "select permission denied on object 'tablename',
database 'databaseName', owner 'dbo'" message. What do I need to modify to
allow the procedure to be able to select from the table

THanks for the help.
G

> New to SQL server. I have created a database in SQL7 and have created a
> table in the database ICFPM. Its really basic, just two fields. I have
> created a new login to the database, and have made the user a member of
> everything.

Seems like you have added the user to the db_denydatareader fixed db role as
well. Deny always supersedes all previous grants, except for the members of
the sysdamin fixed server role. Check the "Adding a Member to a Predefined
Role" and some related topics in Books OnLine.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org