Two options that I can think of:

1. You could drop the indexes, shrink, and then re-create the indexes.

2. Try shrinking the database in multiple steps and releasing space gradually.

Thanks for both the functions!! Both of them were extremely useful.

You could give 'Select' rights on the [SAMPLE].[Dbo].[table1] table to TestUser. In that case TestUser will have access only to that particular table.

Did you try creating a credential through a TSQL script?

Could you please post the solution in this thread too? It sure helps. Thanks!!