Role Security Access

FAQ

Profile

Role Security Access

Database Help (Home) -> Security

Next: Error: OpenQuery with Measures

Author

Message

isjka

External

Since: Aug 15, 2008
Posts: 3

(Msg. 1) Posted: Tue Nov 25, 2008 7:57 am Post subject: Role Security Access Archived from groups: microsoft>public>sqlserver>security (more info?)

Hi, Is it possible to grant a user access in 2005 that allows them to modify/create roles and process cubes only in SSAS? Does this role have the ability to perform any other function? The objective is to limit the role to only creating/modifying roles and processing cubes. This access would be limited to SSAS and nothing else. Thanks. >> Stay informed about: Role Security Access

Display posts from previous:

Related Topics:

.NET Code Access Security fundamentals - "Using the CAS layer is a huge improvement over running extended stored procedures under default login credentials..." (SQL Server 2005 Unleashed, p 1332) Yes, this is wonderful, but in the context of my project, we would all be quite satis...

Can't remove user from role - I have a user in a database role that I cannot remove from the role. If I go into the user's properties and deselect the role, click OK, then go back in, the role is still checked. I've tried to remove them via sp_droprolemember without success. I am..

Creating new user default to DB_owner role - When I create a new SQL login via SSMS the user gets assigned db_owner role by default. This only happens on the one database. Removing the db_owner role during creation of the user causes SSMS to fail with an error because it tries to remove the use...

SQL 2000 user not inheriting permissions from role - In my dbs, the dbo account is assigned to a windows login (I'll call it corp\toomuchaccess) for each db and the corp\toomuchaccess account has SA permission on the server. So, I removed the SA permission on the server, reassigned dbo to have sa as the..

how to find out if a domain user is in the sysadmin server.. - hi, i am trying to find out using T-SQL if a domain user has sysdmin permssions. i can use IS_SRVROLEMEMEBR, but if the user is not a login and directly under the sysadmin role, this function will not help. i need to know even if one of the domain or..

	Database Help (Home) -> Security	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum