Granting Permissions to Roles in SQL Server 2005
- From: stevo1980@xxxxxxxxx
- Date: 12 Feb 2007 16:23:05 -0800
I have several years experience working with SQL 2000 and we are now
also working with SQL Server 2005. I have found Management Studio a
bit tricky to work with, MS seems to have gone backwards in a few
areas.
In Enterprise Manager, permission granting was not the best but it was
simple and worked well. In Management Studio granting permissions to
a new role now seems to be very slow and tedious.
First of all it is about six mouse clicks to browse views only, then
select views one at a time (no ctrl or shift + click allowed), click
OK then you need to click through each view and then click Select (or
whatever rights). Clicking through each view for the first time takes
a few seconds on my laptop (1 user, core 2 duo, 2GB ram!).
I personally try and use the mouse as little as possible, keyboard
shortcuts are much faster. The other problem is that frequently the
role does not save correctly, ie. grant rights then click OK, load the
role again and my changes are gone!
We can't use Schemas because our app references dbo.ObjectName
everywhere and it would be impractical to change this to
Schema.ObjectName, or just ObjectName in all of our code. We did this
because referencing objects as dbo.ObjectName was optimised faster
than just ObjectName.
Has anyone else experienced the same problems?
.
- Follow-Ups:
- Re: Granting Permissions to Roles in SQL Server 2005
- From: Erland Sommarskog
- Re: Granting Permissions to Roles in SQL Server 2005
- From: Sue Hoegemeier
- Re: Granting Permissions to Roles in SQL Server 2005
- Prev by Date: Re: Need help on how to organize users and objects
- Next by Date: Event Id: 17055, Source: MSSQLServer
- Previous by thread: security problem
- Next by thread: Re: Granting Permissions to Roles in SQL Server 2005
- Index(es):
Relevant Pages
|
