web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / prevent access to a co...
Microsoft Dynamics GP (Archived)

prevent access to a company

(0) ShareShare
ReportReport
Posted on by Alvaro Rodríguez Ochoa 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

I have the same question (0)
  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    I usually consider one of two methods, either to track the DYNAMICS..ACTIVITY  for the specific company I am running maintenance on, and when any user logs in I just get the record deleted. This can be automated through a trigger on the table for any records for a specific user other than your user. 

    Another option is to track the sessions created on a specific company on the SQL monitor, and kill any process that access the company database which u are working on.

    Your feedback is highly appreciated, 

  • Alvaro Rodríguez Ochoa Profile Picture
    Alvaro Rodríguez Ochoa 2,395 on at

    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.

  • John Olley Profile Picture
    John Olley 365 on at

    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

  • Alvaro Rodríguez Ochoa Profile Picture
    Alvaro Rodríguez Ochoa 2,395 on at

    Thanks John!

  • Verified answer
    David.Ahalt Profile Picture
    David.Ahalt 470 on at

    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.

  • Alvaro Rodríguez Ochoa Profile Picture
    Alvaro Rodríguez Ochoa 2,395 on at

    This also sounds great Dave, will try it with my test company.

    Regards.

  • Melissa Sandrovich Profile Picture
    Melissa Sandrovich on at

    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.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    At the end of the day, you do have plenty of options to consider Mr. ALVARO

  • Alvaro Rodríguez Ochoa Profile Picture
    Alvaro Rodríguez Ochoa 2,395 on at

    Yes, and all seems to be great ways to do this, thanks to all once again.

    Saludos.

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
HP-11021721-0 Profile Picture

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans