Unable to Create Groups with SQL DB Backend
Hi there,
Need a little assistance with an issue I'm having setting up a SQL DB for use with RDPM.
I have a setup at home that works just fine, this one is for work and I'm locking it down a LOT more. The issue I'm having is that after creating the DB and attaching RDPM to it, I can add sessions and entries, but then can't edit them, neither can I add groups, or access the "Administration" menu from RDPM, it's just greyed out.
Some more info to help.
SQL 2005 full fat, single database created called RDPM, login created through SSMS assigned to AD user, dbo set for the DB specifically not server level, explicit permissions of control, select, connect set on the DB.
Just read over this thread and looks like I've probably gone wrong somewhere. My home setup is much more lax since the DB connection is using a SQL login for rdpmanager and isn't AD integrated.
Any help would be appreciated and a best practice SQL setup guide would be a godsend, can't seem to find one.
Thanks.
The Sun Always Shines In Space
All Comments (2)
Hi
Can you check if you have the following :
Summary list of the user privileges required for RDM users:
admin
• SELECT privilege on master.dbo.syslogins (check if login exists)
• SELECT privilege on sys.database_principals (check if user exists)
• GRANT privilege
• DENY privilege
• CREATE/DROP privilege on USER/LOGIN/TABLE/VIEW/PROC/TRIGGER/FUNCTION
• SELECT, INSERT, DELETE, UPDATE on all tables RDM
• CREATE DATABASE (only required when you create the database, you can revoke after the fact)
non-admin (this will be managed by RDM)
• SELECT, INSERT, DELETE, UPDATE on some/most/all RDM tables depending on user privileges assigned within the RDM user admin screen
Maurice
Hi Maurice,
Thanks for that, be Monday before I can take a look. I'll check it over then and post back.
Thanks again.
The Sun Always Shines In Space