October 11, 2004 at 12:25 pm
OK, I have an Access front end with links to a SQL Server DB. I am going to change it to an Access Project, which ties all tables and queries to tables and views in SQL Server.
This is a good thing. I want my users to be able to create their own views, but I do not want them to create tables.
I cannot find a Role, Server or DB, which will allow one but not the other. I think I need to create a new role, but I looked at the permissions for the roles, but there again, I cannot see one which will allow one but not the other, so that avenue may be out. Any suggestions?
Thanks tons.
Michael Lee
October 11, 2004 at 3:34 pm
Create a user-defined database role for the appropriate database. You can do so in Enterprise Manager or through Query Analyzer. If using QA, you'll want to execute the following (make sure you are in the correct database):
EXEC sp_addrole 'rolename'
As far as granting that role the correct permissions, the easiest way to do so is using QA:
GRANT CREATE VIEW TO [rolename]
You can then add users to the role in order to give them the ability to create views. This does not allow them to create tables.
K. Brian Kelley
@kbriankelley
October 12, 2004 at 7:30 am
Thanks! I knew it was a Dummies question, but it was elusive to me.
Michael Lee
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply