How to quickly toggle permissions?

[jsteph]

Hi all,
Here's the scenario:
I use MS Access as both prototyping tool and often as a quick & dirty front-end tool for many of the sql-2005 databases we have.

The apps connect as that application's sql-user with limited update capabilities. However, I often need to make quick edits of data while debugging an app. In sql-2000, I could go into EM and the permissions dialog had an "Apply" button, so I could leave it open, do my edits, then reset the permissions.

In sql-2005, there is no Apply button--you're forced to hit OK and the entire dialog closes and it's several mouseclicks to get back to the permissions dialog for the table.

This used to take like 5 seconds and I was willing to take the chance that a user won't decide at that moment to go behind the scenes and try to edit the linked tables himself. Also, in sql-2000 when the open dialog was sitting there it was a gentle reminder to me in case I got distracted and forgot that I'd been fiddling with permissions.

Is there a quicker way within the sql-2005 gui to do this?

--Jim

 

[RiverGuy]

Well, you could always precode your before and after permissions in T-SQL and run the script in Management Studio. Wouldn't it be easier though, to use a different login, such as your own, when doing these edits?

 

[jsteph]

Riverguy,
The problem is that I need to log in as the actual user for debugging. I suppose could open another instance logged in under a different user but it's just convenience I'm trying for. It is (or was) easier to just log in once as the user and then if an edit needs to be made I'd do the quick permissions switcheroo in sql server.

Oh well...I'l have to deal with the extra clicks...
--Jim

 

[bluelinenetworks]

Im with the script for before and after on this one.

 

[SQLWilts]

I'm with Riverguy also. All you have to do is select and F5 - simple