Greetings!
Is there a way to change the group id associated with an account based on the client application.
We have all transaction data posted into SQL Server from a custom built Powerbuilder app. Some power users use Access to build and run reports. The problem is that I need to ensure that they have read-only privileges when using Access, but some write access when using the custom app.
Can I change the group assignment while the user is logged in and have it take effect?
To complicate this, this is SQL 6.5 (I've pushed for an upgrade for years).