Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.
Total Post History
7-Day Post History
- New Posts:
- New Topics:
- Active Topics:
Our newest member
All times are UTC [ DST ]
To this end, I have been reading various articles, the most relevant of which are listed below.
It seems to me that I can add permissions for the various tables to a role and then add users to the role, or I can create several schemas for tables, alias the various tables and then add the schema to the role.
At the moment, I am inclined to add the tables to a role, but I am not sure which is best.
Any advice would be great.
So, you could GRANT SELECT, INSERT, UPDATE, DELETE ON DATABASE::<database name> TO <principal>.
-- http://social.msdn.microsoft.com/Forums ... ransactsql
http://stackoverflow.com/questions/7516 ... le-schemas
- LTD Admin
- Posts: 5414
- Joined: Sun Oct 14, 2007 11:26 am
- Posts: 1
- Joined: Mon Oct 13, 2014 7:35 pm