How to disable database switching in Sitecore

Hey, there! Welcome to "Sitecore Series"

Post is all about sharing the details about database switching in Sitecore and how to disable the database switching for few users or roles.

In Sitecore when we login, the default database is set to the master and at the right-bottom corner we have an option to switch to specific data bases like Core database or to Web database.

In specific scenarios, we may want to disable the database switching for various security reasons and to provide right access to the right user.

Giving extra access for an content author is not recommended, as there may be chances of performing unintended actions by accessing the databases and it's content.

So one of the option to provide right access to some content authors is disabling database switch option in Sitecore.


In Sitecore, the editor and all the options we are seeing in master database are configured in Core database. Database switch option is also one of them.

For disabling database switch option to particular user/role, first switch to core database.

Disable Database Switching for specific user:

1) Click on desktop icon in core db.

2) Click on "Security Tools" -> Select "User Manager"

3) Select the user to disable the database switch option ->Click on "Security Editor" from the top menu

4) Navigate to Sitecore -> Content -> Applications -> Desktop -> Tray 

5) Click on Tray and deny the "Read" access for that user.


Disable Database Switching for specific Role:

1) Click on desktop icon in core db.

2) Click on "Security Tools" -> Select "Role Manger"

3) Click on the Role -> Click on security editor from the top menu.

4) Navigate to Sitecore -> Content -> Applications -> Desktop -> Tray  to disable database switching option for this role.

5) Click on Tray and deny the "Read" access for that user.

image


Note: While denying the read access, make sure to check whether the selected role/user is highlighted in the top section.

If any other role/user is highlighted there, that means the changes you are performing are applied to the highlighted role/user.

image


Hope this post helps you. Happy Sitecoring..😊

Comments

Post a Comment

Popular posts from this blog

Overwriting sxa content field in solr document

  Hey ,  there! Welcome to "Sitecore Series" Post is all about sharing the details about "Sitecore SXA search functionality and how to overwrite sxa content field". Sxa search is not returning results even some fields contains the searched text? want to know why it is not searchable and how to fix this?  Trying to generate a search query by passing an extra text like user category/content category and expecting a result with only the matched results where the item in droplist is selected with the same category? but not able to get the expected result? Then this post is for you: Sxa Search Functionality: When Sxa search is configured, if user searched any text in the searchbox it returns the matched result but have you observed this? content that is searchable is actually limits to only few fields content.  By Default the search is limits to single line, multi line and sxa tag fields content.  Sitecore Creates a computed field called "sxacontent_txm" and st...
Read more

Displaying Custom 404 error page for urls with unallowed file extension in sitecore

Hey , there! Welcome to "Sitecore Series" Post is all about displaying custom 404 page for unallowed file extension requests. In Sitecore, we have an option to allow required file extensions and only the allowed file extensions are processed by Sitecore. (Not Sure? How to configure file extensions? Refer my previous post on allowing or blocking specific file extensions in Sitecore) When the custom 404 page is configured, Sitecore will process the URL and maps it with the associated file in webroot or item in Sitecore and displays it. If the file/item is not available, then it will display a custom 404 page. In case of unallowed file extensions, Sitecore will not process the request. Request is directly handled by IIS and redirects to default error page. Oh no! user is seeing default error page, not a good user experience.  Want to know how to configure a custom error page in this scenario? Yeah, this post is for you.   Refer below for the solution: Existing custom 404 page c...
Read more

Sitecore - Task Schedulers and how to schedule a task

Image
Hey ,  there! Welcome to "Sitecore Series" Post is all about sharing the details about "Sitecore Schedulers and how to create and use Schedulers". There are scenarios, where we want a particular task to be executed after some time intervals like for each 15 mins or for each 3 hrs etc.., Below are some sample scenarios: 1) To create a items in CMS tree after reading it from feed. 2) To rebuild/refresh a solr index in specified intervals. 3) To send an email in specified intervals. 4) To clean up items in database. To achieve this, Sitecore provides a feature called scheduler. Where it will allow us to schedule a task to be executed in the specified intervals. Want to know about scheduler creation and how to configure it?  Let's check below steps : 1) Task Creation 2) Configuring a Task in CMS 3) Scheduling a Task. 1) Creating a Task: using Sitecore.Data.Items; using Sitecore.Diagnostics; using Sitecore.Tasks; namespace Testing.Foundation.Testing.Scheduler { ...
Read more

Handling URL requests with different file extensions in Sitecore

Hey   there! Welcome to "Sitecore Series" Post is all about handling URL requests with different file extensions in Sitecore.  In Sitecore, we usually add presentation in items, but what if we want the data to be displayed from the files added in webroot with .txt, .html or any other extensions?  Example Scenarios: 1) Displaying a security file (mysitedomainurl/security.txt) 2) Loading a custom 404 page instead of default error page when the request is handled by IIS (mysitedomainurl/404.aspx or mysitedomainurl/404.html) Here is the solution for different scenarios: Allowing specific extensions : Apply patch by adding required extensions as below: <processor type= "Sitecore.Pipelines.PreprocessRequest.FilterUrlExtensions, Sitecore.Kernel"> <param desc="Allowed extensions (comma seperated)">.txt, .html</param> </processor> Allowing all extensions: <processor type= "Sitecore.Pipelines.PreprocessRequest.FilterUrlExtensi...
Read more

How to rebuild custom solr index programmatically in Sitecore

Image
Hey ,  there! Welcome to "Sitecore Series" Post is all about sharing the details regarding custom index rebuild through code. Sitecore rebuilds indexes data but it does not rebuild indexes very frequently, all depends on the indexing strategies specified for that index. In Sitecore, we have an option to rebuild indexes under control panel and the index rebuild can be performed manually but if we want the index to be rebuild after some operation is done or after some time span? Let's achieve this through scheduler. Create a scheduler to perform index rebuild operation.  1) scheduler : using Sitecore.Data.Items; using Sitecore.Diagnostics; using Sitecore.Tasks; namespace Testing.Feature.Testing.Scheduler { public class TestIndexRunScheduler { public void Execute(Item[] items, CommandItem command, ScheduleItem scheduleItem) { try { //Rebuild Index //Fetch the index to perform rebuild opera...
Read more

Rendering Parameters and Rendering Parameter Templates in Sitecore

Image
Hey ,  there! Welcome to "Sitecore Series" Post is all about sharing the details about rendering parameters and accessing rendering parameters in code. What are rendering parameters? Rendering parameters are used to pass some extra data to a rendering and to give some control to content author on rendering display. Scenarios: 1) To handle a requirement , where the rendering to be displayed with different background colors. 2) To display a component in different ways based on the value selection. 3) Applying different css classes to the rendering. 1) How to Create Rendering Parameters: Let's take a look at below steps to understand the rendering parameters creation. As we all know the data templates are created from "standard template" but for rendering parameters the template to be created from  "Standard Rendering Parameters Template" Here is the path for the Standard Rendering Parameters Template: Templates/System/Layout/Rendering Parameters/Standard...
Read more

Accessing Items from Sitecore Database in different scenarios

Hey ,  there! Welcome to "Sitecore Series" Post is all about sharing the details about "Accessing items from Databases and about Sitecore.Context.Database in different scenarios". Sitecore.Context.Database.GetItem() returning null even the items exists in the Database? Want to know more details why this is not returning any results or null? You are on right place, check below for details. Let's dig into different scenarios and ways to access database to understand more about this: Different ways to access Databases: 1) Sitecore.Data.Database database = Sitecore.Context.Database; 2) Sitecore.Data.Database database = Sitecore.Configuration.Factory.GetDatabase("master"); 3) Sitecore.Data.Database database = Sitecore.Data.Database.GetDatabase("master"); Last 2 approaches works as expected, but the issue here is we have hardcoded the database values. In the 2&3 approaches, if the piece of code is executed from CD site it will throw an error...
Read more