Solved

Exchange 2013 Giving one user access to 28 other users calenders. publishing editor rights ? in one go

Posted on 2016-10-25
7
68 Views
Last Modified: 2016-10-27
Hi All
can you all help with the above issue I'd like to give one user in one go access rights to 28 other users calendar publishing editor rights
thank you all for your help
0
Comment
Question by:MarK PercY
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 16

Expert Comment

by:Todd Nelson
ID: 41858782
I recommend you create a CSV file with all of the names of the users the one user needs access to.  Similar to this...

Alias,NAME_OF_USER_THAT_NEEDS_ACCESS
JDoe,Me
BDoe,Me
JSmith,Me
BSmith,Me

Open in new window


This command should add the permissions you need for the one user to access all of the calendars specified in the CSV file...

Import-Csv "C:\Users.csv" | ForEach-Object { Add-MailboxFolderPermission –Identity ($_.Alias + ’:\calendar’) –User $_.NAME_OF_USER_THAT_NEEDS_ACCESS –AccessRights PublishingEditor }

Open in new window


However, if the one user already has permissions set and they need to be modified, you will use this command...

Import-Csv "C:\Users.csv" | ForEach-Object { Set-MailboxFolderPermission –Identity ($_.Alias + ’:\calendar’) –User $_.NAME_OF_USER_THAT_NEEDS_ACCESS –AccessRights PublishingEditor }

Open in new window


Let us know.
1
 

Author Comment

by:MarK PercY
ID: 41860162
Hi Todd,

Thank you once again for the above information these are the users & this is what she needs.
Can you support with this please?.&should I start learning PowerShell & do you have any suggestions
Thank you for your support by the way its been invaluable


I need to be publishing editor to the following:

Amalia Khemet
Amy Farrell
Andrew White
Anna Holland
Caroline Barnet
Charlotte Hynes
Chris Bruce
Guy Sumaili
Jackie O’Rourke
Jack Lynch
Jake Fowler
Joanna Drake
Jordan Blake
Kiran Kaur
Kirsty Hull
Luke Guest
Matthew Redmond
Matthew Wallis
Meg Harris
Natasha Nabbijan
Nimerjeet Kaur
Raphael Sanglay
Rebecca Collins
Rebecca Rae
Shannon Barnes
Sophie Burgess
Stephanie Matthews
Tayo Omole
Victoria Davies
0
 
LVL 16

Expert Comment

by:Todd Nelson
ID: 41860333
The CSV will look like the following.  Save as "Users.csv" on C: ...

Alias
Amalia Khemet
Amy Farrell
Andrew White
Anna Holland
Caroline Barnet
Charlotte Hynes
Chris Bruce
Guy Sumaili
Jackie O’Rourke
Jack Lynch
Jake Fowler
Joanna Drake
Jordan Blake
Kiran Kaur
Kirsty Hull
Luke Guest
Matthew Redmond
Matthew Wallis
Meg Harris
Natasha Nabbijan
Nimerjeet Kaur
Raphael Sanglay
Rebecca Collins
Rebecca Rae
Shannon Barnes
Sophie Burgess
Stephanie Matthews
Tayo Omole
Victoria Davies

Open in new window


Then run this command in the Exchange Management Shell...

Import-Csv "C:\Users.csv" | ForEach-Object { Add-MailboxFolderPermission –Identity ($_.Alias + ’:\calendar’) –User "ENTER THE NAME OF USER THAT NEEDS ACCESS HERE" –AccessRights PublishingEditor }

Open in new window


After running the command, should you receive an error like this...

An existing permission entry was found for user: ...


You will need to run this command...

Import-Csv "C:\Users.csv" | ForEach-Object { Set-MailboxFolderPermission –Identity ($_.Alias + ’:\calendar’) –User "ENTER THE NAME OF USER THAT NEEDS ACCESS HERE" –AccessRights PublishingEditor }

Open in new window


If you want to see if the permissions were set properly, run this command...

Import-Csv "C:\Users.csv" | ForEach-Object { Get-MailboxFolderPermission ($_.Alias + ':\calendar') }

Open in new window


Hope that helps.

Should I start learning PowerShell?

Yes. If that is what you want.


Do you have any suggestions?

Get yourself a lab server ... http://www.expta.com/2016/05/expta-gen7-home-lab-server-builds-and.html
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:MarK PercY
ID: 41861782
Hi Todd,

Thank you for this information it is so helpful & supportive. Please would you mind having a look at the screenshots I've added when I run the first script via Exchange Management Shell I get an error message.

Import-Csv "C:\Users.csv" | ForEach-Object { Add-MailboxFolderPermission –Identity ($_.Alias + ’:\calendar’) –User " Louise Lanahan  " –AccessRights PublishingEditor }

Can you help?
Hi-Todd.docx
0
 

Author Comment

by:MarK PercY
ID: 41862240
Can anyone help
0
 
LVL 16

Accepted Solution

by:
Todd Nelson earned 500 total points
ID: 41862286
The first screenshot suggests the CSV is not on the C drive or the name of the CSV is not "Users.csv".

In the second screenshot, the command is out of context.  You need to run the entire command as was provided ... including the Import-Csv.  It's a one line command.

Also, remove the spaces between the quotes (" Louise Lanahan  "), like this...

Import-Csv "C:\Users.csv" | ForEach-Object { Add-MailboxFolderPermission –Identity ($_.Alias + ’:\calendar’) –User "Louise Lanahan" –AccessRights PublishingEditor }

Open in new window


Or you will get an error like this...


The user " Louise Lanahan  " is either not valid SMTP address, or there is no matching information.
0
 

Author Closing Comment

by:MarK PercY
ID: 41862430
fantastic support
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question