Maybe the function name is too long?

Thanks Grant

I accept your point - why is the system giving me a "select permission denied" when using the scalar variable in a select statement, when the user is not...

Thanks Scott I can confirm no Deny in database.

I can only grant execute not select permission to the scalar function. The error is stating select permission denied - as mentioned...

Hi Anthony

Fully concur with your comments, there must be something else going on here as I am using SSRS 2012 and nobody can access reports unless the person or an...

Hi Anthony

Apologies I am not understanding your second paragraph. Your initial reply stated:

eg I have a root folder of business. Two sub folders of marketing and finance I set permissions...

Thanks Anthony

I have already browsed that article, I have found the same as you for SSRS 2016 that as long as the URL destination has permission it doesn't matter about...

• This reply was modified 3 years, 11 months ago by  graham.measures.

Hi Thom
Thanks for this.
So as you have stated you can create an orphaned user in a database.(tuser)
If that user has inherited AD permissions from another group (Testusers)...

Hi Thom
Thank you for the reply.
In your test scenario NT/Thom is a database user of database StaffRecords.
Is there a sql server user for NT/Thom, and if not...

Thank you for the reply. We will be upgrading to SQL server 2012 mid 2014 so I may just wait until then.

Regards

Thanks for the reply

Do you mean to check with Microsoft that the Excel 2013 version behaves correctly with SQL Server 2005?

Regards