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.
| Author |
Topic |
|
matthisco
Starting Member
48 Posts |
 Posted - 2010-05-27 : 09:19:31
|
| Hi Folks, I need to setup a user access to a table so he can connect using Access, and create his own queries.I dont want him seeing all the tables in the database. Can someone please tell me how to do this step by step?Many thanks |
|
|
matthisco
Starting Member
48 Posts |
Posted - 2010-05-28 : 05:34:37
|
| Anyone? |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-05-28 : 17:06:38
|
| grant select,insert... on <tablenaem> to <username> |
|
|
|
matthisco
Starting Member
48 Posts |
Posted - 2010-06-01 : 07:39:56
|
quote:
Originally posted by Peter99
grant select,insert... on <tablenaem> to <username>
Thanks for your reply.I now get the error:CREATE VIEW permission denied in database 'xxxx'"I am trying to setup a connection to the db using an access 2007 adp file.Can you please tell me how I Can solve it?Thanks |
|
|
|
|
|
|
Give user access to single table