You’re offline. This is a read only version of the page.
2,395
Hi, what is the best way to prevent users from accesing a company with out removing them from the company table, since this removes all the permissions to this company?
From time to time I need to run some maintanence to a company and I ask all users to not login into this company, but they keep login in, how can I prevent this?-
Regards.
*This post is locked for comments
On a side note check out a new feature in GP 2013 R2 which will allow you to take databases offline :)
The PSTL (Professional Services Tools Library) has a tool called Database Disabler - you can use this to temporarily disable companies for all users except 'sa'. The PSTL is free and can be installed from the GP installation media for the latest few releases of Dynamics GP.
Yes, and all seems to be great ways to do this, thanks to all once again.
Saludos.
At the end of the day, you do have plenty of options to consider Mr. ALVARO
If this is something you need to do often and with a large number of users, there is a third party product that will allow you to prevent this. Rockton had a Toolbox product that will accomplish this and many other nuances in GP.
This also sounds great Dave, will try it with my test company.
Regards.
Working with a large number of users and companies, I have found it useful to change the company id in the dynamics sy06100 table temporarily. Just making sure the new number is not in use. In this case I change company 12 to 112.
update dynamics.dbo.sy60100 set cmpanyid = 112 where userid not in ('sa','dynsa') and cmpanyid = 12
This changes the users to a database that does not exist and they cannot log into 12 which is being worked on. When I am finished I run the reverse changing the 112 back to 12. It has come in handy when only needing to work on one company and allow users to continue to work in other companies.
Thanks John!
Would putting the database in Single User mode help? In SSMS - Right click the database name, properties, options, scroll to the bottom, change restrict access to what you need to use. Then just change it back when you are done. I don't know if this would stop you from logging into it though if other processes are running. They might act as a 'user' and tie that single user spot up. Just something I thought you could try out.
technet.microsoft.com/.../ms345598.aspx
Thanks,
John Olley
I like the track the DYNAMICS..ACTIVITY table solution, will do it that way.
I think Microsoft should consider and easy way to temporarilly disable acces to a company from users other than SA.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (