Tagged Questions

2
votes
2answers
73 views

SQL Server EE: Restricting access to users logging in through the Microsoft server management tool [closed]

We have a database in SQL server express edition which is used by a third party application for storing data. When the users login to through this third party program their windows authentication is ...
0
votes
1answer
782 views

SSAS Roles - Creating a Role to restrict access to the cube, by country

I'm trying to create a role, to restrict access to a cube on Analysis services, so that a member of this role can only see records related to a specific country (from a dim_country dimension). So, for ...
2
votes
1answer
86 views

Role with owner privilege?

How can i create new role and provide owner privilege for specific database in SQL Server?
0
votes
1answer
79 views

Fixed Server roles

Can users who are members of SQL2008's server DBCreator role, access databases created/restored by another user with the same permissions, without having to grant any additional permissions?
1
vote
1answer
845 views

Scripting MS SQL Server 2000/2008 Roles

I'm currently migrating a MS SQL Server from 2000 to 2008. I really want to migrate all of the roles (including all members and permissions of that role) from the 2000 box by scripting them. Then, on ...