Hi All
Is it possible to grant a user permissons so they are
only able to execute a SQL Job and not have access to
anything else in a database.
Thanks
Hi
Yes, altough not with job, but with stored procecdure.
Andras Jakus MCDBA
"anonymous@.discussions.microsoft.com" wrote:
> Hi All
> Is it possible to grant a user permissons so they are
> only able to execute a SQL Job and not have access to
> anything else in a database.
> Thanks
>
Showing posts with label permissons. Show all posts
Showing posts with label permissons. Show all posts
Monday, March 26, 2012
Wednesday, March 21, 2012
Permissions on linked reports with subreport
Need help please...
I have one folder 'RSFOLDER' with all reports and subreports in it. I don't
wont to set any permissons on that folder. This fodler is hidden...
I have second folder. That folder is not hidden, it has user friendly name,
and contains linked reports from folder RSFOLDER.
Users have permissions on linked reports.
When user open some report that contains subreport, report renders fine, but
subreports are missing (Error: Report could not be shown...)
When I set up permissions on RSFOLDER everithing is fine...
Any workaround?
Tnnx,
nikolaCreate another level of folders
/RSFolder <-- User's don't have permission
/RSFolder/folder <-- users have permission to read
Then all the reports will be accessible but user can't directly navigate to
them. Another option is to set the permission on each report explicitly.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nikola Smircic" <nikola.smircic@.netlab.hr> wrote in message
news:e2qzadxpEHA.1308@.TK2MSFTNGP14.phx.gbl...
> Need help please...
> I have one folder 'RSFOLDER' with all reports and subreports in it. I
don't
> wont to set any permissons on that folder. This fodler is hidden...
> I have second folder. That folder is not hidden, it has user friendly
name,
> and contains linked reports from folder RSFOLDER.
> Users have permissions on linked reports.
> When user open some report that contains subreport, report renders fine,
but
> subreports are missing (Error: Report could not be shown...)
> When I set up permissions on RSFOLDER everithing is fine...
> Any workaround?
> Tnnx,
> nikola
>sql
I have one folder 'RSFOLDER' with all reports and subreports in it. I don't
wont to set any permissons on that folder. This fodler is hidden...
I have second folder. That folder is not hidden, it has user friendly name,
and contains linked reports from folder RSFOLDER.
Users have permissions on linked reports.
When user open some report that contains subreport, report renders fine, but
subreports are missing (Error: Report could not be shown...)
When I set up permissions on RSFOLDER everithing is fine...
Any workaround?
Tnnx,
nikolaCreate another level of folders
/RSFolder <-- User's don't have permission
/RSFolder/folder <-- users have permission to read
Then all the reports will be accessible but user can't directly navigate to
them. Another option is to set the permission on each report explicitly.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nikola Smircic" <nikola.smircic@.netlab.hr> wrote in message
news:e2qzadxpEHA.1308@.TK2MSFTNGP14.phx.gbl...
> Need help please...
> I have one folder 'RSFOLDER' with all reports and subreports in it. I
don't
> wont to set any permissons on that folder. This fodler is hidden...
> I have second folder. That folder is not hidden, it has user friendly
name,
> and contains linked reports from folder RSFOLDER.
> Users have permissions on linked reports.
> When user open some report that contains subreport, report renders fine,
but
> subreports are missing (Error: Report could not be shown...)
> When I set up permissions on RSFOLDER everithing is fine...
> Any workaround?
> Tnnx,
> nikola
>sql
Subscribe to:
Posts (Atom)