October 5, 2009 at 6:39 am
Is it possible to have a filegroup where only specific users can access the tables of the filegroup, or is there any way to restrict users from accessing some of the tables in the DB.
October 5, 2009 at 6:50 am
You can't do this by Filegroup since a filegroup is a physical structure. The user and tables are logical structures.
also, what about indexes? You don't necessarily have indexes on the filegroup with the table.
By default, a user has no rights to any table. You grant them access to a table. If they've achieved it through a role, you can create another role, give it DENY rights for the table, and then add the user to the new role.
October 5, 2009 at 7:05 am
Thanks for the quick reply.
actually i am looking to spit my database.
My application has administration (configurations) and functional(business) tables, and want to seperate this out where admin will have access to admin tables and users will have access to remaining, but still these have some dependencies on each other.
October 5, 2009 at 7:28 am
You can use schemas to do this. Filegroups are used for performance separation, not logical separation.
Also, if you create two roles, you can assign rights as needed to each group. If users do not have a right, they will not see the table.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply