Hi all,
I have user defined functions in master databases such as
system_function_schema.fn_chariswhitespace
As default this kind of functions have a public permissions for EXEC, but I
want to remove this
When I execute the sentece
REVOKE EXEC ON system_function_schema.fn_chariswhitespace TO PUBLIC
I got nex error
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'system_function_schema.fn_chariswhitespace'.
I have SQL Server 2000 64 bits.
Can anybody help me?
Thanks in advance,
Javier RosasHi,
You are using an undocumented/unsupported featured. The
system_function_schema doesn't exist in SQL 2005 and you will have
difficulties upgrading your code.
I recommend you abandon use of the system_function_schema
Regards,
Clifford Dibble
"Javier Rosas" wrote:
> Hi all,
> I have user defined functions in master databases such as
> system_function_schema.fn_chariswhitespace
> As default this kind of functions have a public permissions for EXEC, but
I
> want to remove this
> When I execute the sentece
> REVOKE EXEC ON system_function_schema.fn_chariswhitespace TO PUBLIC
> I got nex error
> Server: Msg 208, Level 16, State 11, Line 1
> Invalid object name 'system_function_schema.fn_chariswhitespace'.
> I have SQL Server 2000 64 bits.
> Can anybody help me?
> Thanks in advance,
> Javier Rosas
Showing posts with label functions. Show all posts
Showing posts with label functions. Show all posts
Friday, March 23, 2012
Monday, March 12, 2012
Permissions and Administration
Do you have to be a member of the local win2K administrators group in-order
to perform administration functions and create folders in Reporting Services?Any user can be given permissions to administer Reporting Services. If
using Forms Authentication, you don't have Windows users at all. In that
case, you can set a default administrator account in the
RSReportServer.config file (replace "USERNAMEHERE"):
<Security>
<Extension Name="Forms"
Type="RSCustomSecurity.Authorization,
ReportingServices.RSCustomSecurity" >
<Configuration>
<AdminConfiguration>
<UserName>USERNAMEHERE</UserName>
</AdminConfiguration>
</Configuration>
</Extension>
</Security>
I haven't tried setting the AdminConfiguration UserName for when Extension
Name="Windows", but it may be worth a shot.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Andy998" <Andy998@.discussions.microsoft.com> wrote in message
news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> Do you have to be a member of the local win2K administrators group
> in-order
> to perform administration functions and create folders in Reporting
> Services?|||When we installed RS on a production server, we can't see the contents or
properties tab on the home page. We also do not see the New Folder or New
Data Source or Upload Files buttons and therefore can not create folders.
We had the NT administrator go into Site Settings page and add our NT
accounts on the System Role Assignments page as systems administrators, but
that did not help either. This works fine on our development server but were
also in the local admin group on that server.
"Jeff A. Stucker" wrote:
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>
>|||Hi,
I have the exact same issue. I have tried the suggested workaround below,
but the problem presists. Do you have any other ideas?
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>|||I have the exact same issue.
I have tried the workaround below, but problem persists.
pls help.
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>|||No I have not found the answer for this. I am starting to believe this
product is more trouble than it's worth. If I figure this out I'll let you
know.
"RIchard Baldock" wrote:
> I have the exact same issue.
> I have tried the workaround below, but problem persists.
> pls help.
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Any user can be given permissions to administer Reporting Services. If
> > using Forms Authentication, you don't have Windows users at all. In that
> > case, you can set a default administrator account in the
> > RSReportServer.config file (replace "USERNAMEHERE"):
> >
> > <Security>
> > <Extension Name="Forms"
> > Type="RSCustomSecurity.Authorization,
> > ReportingServices.RSCustomSecurity" >
> > <Configuration>
> > <AdminConfiguration>
> > <UserName>USERNAMEHERE</UserName>
> > </AdminConfiguration>
> > </Configuration>
> > </Extension>
> > </Security>
> >
> > I haven't tried setting the AdminConfiguration UserName for when Extension
> > Name="Windows", but it may be worth a shot.
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > Do you have to be a member of the local win2K administrators group
> > > in-order
> > > to perform administration functions and create folders in Reporting
> > > Services?
> >
> >
>
>|||I have resolved this issue.
Follow these steps.
1. have an windows administrator go to to the report server web page.
click sitesetting and add you Windowns account as a systems administrator.
2. Have the windows administrator then got to the home page press new
folder and create your new folder, The have them add your windows local group
or domain account as a content manager for this new folder.
Once this is complete you should see this folder on the home page as well as
the New folder, New Data Source asnd Upload buttons.
Andy
"RIchard Baldock" wrote:
> I have the exact same issue.
> I have tried the workaround below, but problem persists.
> pls help.
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Any user can be given permissions to administer Reporting Services. If
> > using Forms Authentication, you don't have Windows users at all. In that
> > case, you can set a default administrator account in the
> > RSReportServer.config file (replace "USERNAMEHERE"):
> >
> > <Security>
> > <Extension Name="Forms"
> > Type="RSCustomSecurity.Authorization,
> > ReportingServices.RSCustomSecurity" >
> > <Configuration>
> > <AdminConfiguration>
> > <UserName>USERNAMEHERE</UserName>
> > </AdminConfiguration>
> > </Configuration>
> > </Extension>
> > </Security>
> >
> > I haven't tried setting the AdminConfiguration UserName for when Extension
> > Name="Windows", but it may be worth a shot.
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > Do you have to be a member of the local win2K administrators group
> > > in-order
> > > to perform administration functions and create folders in Reporting
> > > Services?
> >
> >
>
>|||I logged on as the local administrator and yes I got to the home page and
added my domain account as a systems adminstrator.
I could see all the tabs.
But then logging on as myself, I still only see the 'contents' tab.
I went back as adminstrator to check, and as adminstrator I can only see the
contents tab !!!
I am really stumped by this - it is like you say a "very difficult" product.
Do you (or anyone) have any ideas , I'm desperate.
"ANDY998" <ANDY998@.discussions.microsoft.com> wrote in message
news:284DD604-9DFE-4448-BF9A-D6D2DD03277E@.microsoft.com...
> I have resolved this issue.
> Follow these steps.
> 1. have an windows administrator go to to the report server web page.
> click sitesetting and add you Windowns account as a systems administrator.
> 2. Have the windows administrator then got to the home page press new
> folder and create your new folder, The have them add your windows local
group
> or domain account as a content manager for this new folder.
> Once this is complete you should see this folder on the home page as well
as
> the New folder, New Data Source asnd Upload buttons.
> Andy
> "RIchard Baldock" wrote:
> > I have the exact same issue.
> > I have tried the workaround below, but problem persists.
> > pls help.
> >
> >
> > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > Any user can be given permissions to administer Reporting Services.
If
> > > using Forms Authentication, you don't have Windows users at all. In
that
> > > case, you can set a default administrator account in the
> > > RSReportServer.config file (replace "USERNAMEHERE"):
> > >
> > > <Security>
> > > <Extension Name="Forms"
> > > Type="RSCustomSecurity.Authorization,
> > > ReportingServices.RSCustomSecurity" >
> > > <Configuration>
> > > <AdminConfiguration>
> > > <UserName>USERNAMEHERE</UserName>
> > > </AdminConfiguration>
> > > </Configuration>
> > > </Extension>
> > > </Security>
> > >
> > > I haven't tried setting the AdminConfiguration UserName for when
Extension
> > > Name="Windows", but it may be worth a shot.
> > > --
> > > Cheers,
> > >
> > > '(' Jeff A. Stucker
> > > \
> > >
> > > Business Intelligence
> > > www.criadvantage.com
> > > ---
> > > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > > Do you have to be a member of the local win2K administrators group
> > > > in-order
> > > > to perform administration functions and create folders in Reporting
> > > > Services?
> > >
> > >
> >
> >
> >|||I have "solved" this.
1. If you would like to see & use all the TABS on the "/Reports" Virtual
directory - disable anonymous access on both the "/Reports" and
"/Reportserver" Virtual directories.
Or
2. If you need to provide anonymous access to your "/Reportserver " virtual
directory then you will not be able to see & use all the TABS on "/Reports"
virtual directory simultaneously.
The obvious workaround is point 1 above. These can be shuffled as required.
Shitty but true. I guess this release was not "intended" to be used over web
etc ?
"RIchard Baldock" <RIchardBaldock@.community.nospam> wrote in message
news:e9SGPKb4EHA.3644@.tk2msftngp13.phx.gbl...
> I logged on as the local administrator and yes I got to the home page and
> added my domain account as a systems adminstrator.
> I could see all the tabs.
> But then logging on as myself, I still only see the 'contents' tab.
> I went back as adminstrator to check, and as adminstrator I can only see
the
> contents tab !!!
> I am really stumped by this - it is like you say a "very difficult"
product.
> Do you (or anyone) have any ideas , I'm desperate.
>
> "ANDY998" <ANDY998@.discussions.microsoft.com> wrote in message
> news:284DD604-9DFE-4448-BF9A-D6D2DD03277E@.microsoft.com...
> > I have resolved this issue.
> >
> > Follow these steps.
> >
> > 1. have an windows administrator go to to the report server web page.
> > click sitesetting and add you Windowns account as a systems
administrator.
> >
> > 2. Have the windows administrator then got to the home page press new
> > folder and create your new folder, The have them add your windows local
> group
> > or domain account as a content manager for this new folder.
> >
> > Once this is complete you should see this folder on the home page as
well
> as
> > the New folder, New Data Source asnd Upload buttons.
> >
> > Andy
> >
> > "RIchard Baldock" wrote:
> >
> > > I have the exact same issue.
> > > I have tried the workaround below, but problem persists.
> > > pls help.
> > >
> > >
> > > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > > news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > > Any user can be given permissions to administer Reporting Services.
> If
> > > > using Forms Authentication, you don't have Windows users at all. In
> that
> > > > case, you can set a default administrator account in the
> > > > RSReportServer.config file (replace "USERNAMEHERE"):
> > > >
> > > > <Security>
> > > > <Extension Name="Forms"
> > > > Type="RSCustomSecurity.Authorization,
> > > > ReportingServices.RSCustomSecurity" >
> > > > <Configuration>
> > > > <AdminConfiguration>
> > > > <UserName>USERNAMEHERE</UserName>
> > > > </AdminConfiguration>
> > > > </Configuration>
> > > > </Extension>
> > > > </Security>
> > > >
> > > > I haven't tried setting the AdminConfiguration UserName for when
> Extension
> > > > Name="Windows", but it may be worth a shot.
> > > > --
> > > > Cheers,
> > > >
> > > > '(' Jeff A. Stucker
> > > > \
> > > >
> > > > Business Intelligence
> > > > www.criadvantage.com
> > > > ---
> > > > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > > > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > > > Do you have to be a member of the local win2K administrators group
> > > > > in-order
> > > > > to perform administration functions and create folders in
Reporting
> > > > > Services?
> > > >
> > > >
> > >
> > >
> > >
>
to perform administration functions and create folders in Reporting Services?Any user can be given permissions to administer Reporting Services. If
using Forms Authentication, you don't have Windows users at all. In that
case, you can set a default administrator account in the
RSReportServer.config file (replace "USERNAMEHERE"):
<Security>
<Extension Name="Forms"
Type="RSCustomSecurity.Authorization,
ReportingServices.RSCustomSecurity" >
<Configuration>
<AdminConfiguration>
<UserName>USERNAMEHERE</UserName>
</AdminConfiguration>
</Configuration>
</Extension>
</Security>
I haven't tried setting the AdminConfiguration UserName for when Extension
Name="Windows", but it may be worth a shot.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Andy998" <Andy998@.discussions.microsoft.com> wrote in message
news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> Do you have to be a member of the local win2K administrators group
> in-order
> to perform administration functions and create folders in Reporting
> Services?|||When we installed RS on a production server, we can't see the contents or
properties tab on the home page. We also do not see the New Folder or New
Data Source or Upload Files buttons and therefore can not create folders.
We had the NT administrator go into Site Settings page and add our NT
accounts on the System Role Assignments page as systems administrators, but
that did not help either. This works fine on our development server but were
also in the local admin group on that server.
"Jeff A. Stucker" wrote:
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>
>|||Hi,
I have the exact same issue. I have tried the suggested workaround below,
but the problem presists. Do you have any other ideas?
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>|||I have the exact same issue.
I have tried the workaround below, but problem persists.
pls help.
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>|||No I have not found the answer for this. I am starting to believe this
product is more trouble than it's worth. If I figure this out I'll let you
know.
"RIchard Baldock" wrote:
> I have the exact same issue.
> I have tried the workaround below, but problem persists.
> pls help.
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Any user can be given permissions to administer Reporting Services. If
> > using Forms Authentication, you don't have Windows users at all. In that
> > case, you can set a default administrator account in the
> > RSReportServer.config file (replace "USERNAMEHERE"):
> >
> > <Security>
> > <Extension Name="Forms"
> > Type="RSCustomSecurity.Authorization,
> > ReportingServices.RSCustomSecurity" >
> > <Configuration>
> > <AdminConfiguration>
> > <UserName>USERNAMEHERE</UserName>
> > </AdminConfiguration>
> > </Configuration>
> > </Extension>
> > </Security>
> >
> > I haven't tried setting the AdminConfiguration UserName for when Extension
> > Name="Windows", but it may be worth a shot.
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > Do you have to be a member of the local win2K administrators group
> > > in-order
> > > to perform administration functions and create folders in Reporting
> > > Services?
> >
> >
>
>|||I have resolved this issue.
Follow these steps.
1. have an windows administrator go to to the report server web page.
click sitesetting and add you Windowns account as a systems administrator.
2. Have the windows administrator then got to the home page press new
folder and create your new folder, The have them add your windows local group
or domain account as a content manager for this new folder.
Once this is complete you should see this folder on the home page as well as
the New folder, New Data Source asnd Upload buttons.
Andy
"RIchard Baldock" wrote:
> I have the exact same issue.
> I have tried the workaround below, but problem persists.
> pls help.
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Any user can be given permissions to administer Reporting Services. If
> > using Forms Authentication, you don't have Windows users at all. In that
> > case, you can set a default administrator account in the
> > RSReportServer.config file (replace "USERNAMEHERE"):
> >
> > <Security>
> > <Extension Name="Forms"
> > Type="RSCustomSecurity.Authorization,
> > ReportingServices.RSCustomSecurity" >
> > <Configuration>
> > <AdminConfiguration>
> > <UserName>USERNAMEHERE</UserName>
> > </AdminConfiguration>
> > </Configuration>
> > </Extension>
> > </Security>
> >
> > I haven't tried setting the AdminConfiguration UserName for when Extension
> > Name="Windows", but it may be worth a shot.
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > Do you have to be a member of the local win2K administrators group
> > > in-order
> > > to perform administration functions and create folders in Reporting
> > > Services?
> >
> >
>
>|||I logged on as the local administrator and yes I got to the home page and
added my domain account as a systems adminstrator.
I could see all the tabs.
But then logging on as myself, I still only see the 'contents' tab.
I went back as adminstrator to check, and as adminstrator I can only see the
contents tab !!!
I am really stumped by this - it is like you say a "very difficult" product.
Do you (or anyone) have any ideas , I'm desperate.
"ANDY998" <ANDY998@.discussions.microsoft.com> wrote in message
news:284DD604-9DFE-4448-BF9A-D6D2DD03277E@.microsoft.com...
> I have resolved this issue.
> Follow these steps.
> 1. have an windows administrator go to to the report server web page.
> click sitesetting and add you Windowns account as a systems administrator.
> 2. Have the windows administrator then got to the home page press new
> folder and create your new folder, The have them add your windows local
group
> or domain account as a content manager for this new folder.
> Once this is complete you should see this folder on the home page as well
as
> the New folder, New Data Source asnd Upload buttons.
> Andy
> "RIchard Baldock" wrote:
> > I have the exact same issue.
> > I have tried the workaround below, but problem persists.
> > pls help.
> >
> >
> > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > Any user can be given permissions to administer Reporting Services.
If
> > > using Forms Authentication, you don't have Windows users at all. In
that
> > > case, you can set a default administrator account in the
> > > RSReportServer.config file (replace "USERNAMEHERE"):
> > >
> > > <Security>
> > > <Extension Name="Forms"
> > > Type="RSCustomSecurity.Authorization,
> > > ReportingServices.RSCustomSecurity" >
> > > <Configuration>
> > > <AdminConfiguration>
> > > <UserName>USERNAMEHERE</UserName>
> > > </AdminConfiguration>
> > > </Configuration>
> > > </Extension>
> > > </Security>
> > >
> > > I haven't tried setting the AdminConfiguration UserName for when
Extension
> > > Name="Windows", but it may be worth a shot.
> > > --
> > > Cheers,
> > >
> > > '(' Jeff A. Stucker
> > > \
> > >
> > > Business Intelligence
> > > www.criadvantage.com
> > > ---
> > > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > > Do you have to be a member of the local win2K administrators group
> > > > in-order
> > > > to perform administration functions and create folders in Reporting
> > > > Services?
> > >
> > >
> >
> >
> >|||I have "solved" this.
1. If you would like to see & use all the TABS on the "/Reports" Virtual
directory - disable anonymous access on both the "/Reports" and
"/Reportserver" Virtual directories.
Or
2. If you need to provide anonymous access to your "/Reportserver " virtual
directory then you will not be able to see & use all the TABS on "/Reports"
virtual directory simultaneously.
The obvious workaround is point 1 above. These can be shuffled as required.
Shitty but true. I guess this release was not "intended" to be used over web
etc ?
"RIchard Baldock" <RIchardBaldock@.community.nospam> wrote in message
news:e9SGPKb4EHA.3644@.tk2msftngp13.phx.gbl...
> I logged on as the local administrator and yes I got to the home page and
> added my domain account as a systems adminstrator.
> I could see all the tabs.
> But then logging on as myself, I still only see the 'contents' tab.
> I went back as adminstrator to check, and as adminstrator I can only see
the
> contents tab !!!
> I am really stumped by this - it is like you say a "very difficult"
product.
> Do you (or anyone) have any ideas , I'm desperate.
>
> "ANDY998" <ANDY998@.discussions.microsoft.com> wrote in message
> news:284DD604-9DFE-4448-BF9A-D6D2DD03277E@.microsoft.com...
> > I have resolved this issue.
> >
> > Follow these steps.
> >
> > 1. have an windows administrator go to to the report server web page.
> > click sitesetting and add you Windowns account as a systems
administrator.
> >
> > 2. Have the windows administrator then got to the home page press new
> > folder and create your new folder, The have them add your windows local
> group
> > or domain account as a content manager for this new folder.
> >
> > Once this is complete you should see this folder on the home page as
well
> as
> > the New folder, New Data Source asnd Upload buttons.
> >
> > Andy
> >
> > "RIchard Baldock" wrote:
> >
> > > I have the exact same issue.
> > > I have tried the workaround below, but problem persists.
> > > pls help.
> > >
> > >
> > > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > > news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > > Any user can be given permissions to administer Reporting Services.
> If
> > > > using Forms Authentication, you don't have Windows users at all. In
> that
> > > > case, you can set a default administrator account in the
> > > > RSReportServer.config file (replace "USERNAMEHERE"):
> > > >
> > > > <Security>
> > > > <Extension Name="Forms"
> > > > Type="RSCustomSecurity.Authorization,
> > > > ReportingServices.RSCustomSecurity" >
> > > > <Configuration>
> > > > <AdminConfiguration>
> > > > <UserName>USERNAMEHERE</UserName>
> > > > </AdminConfiguration>
> > > > </Configuration>
> > > > </Extension>
> > > > </Security>
> > > >
> > > > I haven't tried setting the AdminConfiguration UserName for when
> Extension
> > > > Name="Windows", but it may be worth a shot.
> > > > --
> > > > Cheers,
> > > >
> > > > '(' Jeff A. Stucker
> > > > \
> > > >
> > > > Business Intelligence
> > > > www.criadvantage.com
> > > > ---
> > > > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > > > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > > > Do you have to be a member of the local win2K administrators group
> > > > > in-order
> > > > > to perform administration functions and create folders in
Reporting
> > > > > Services?
> > > >
> > > >
> > >
> > >
> > >
>
Friday, March 9, 2012
permissions
Hi All,
how I can setup a role, so that they can only create, drop stored procedure,
views and functions. and can't create triggers, tables or modify schema.
Tim
grant create procedure, create view, create function to <login>
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"t" <t@.t.t> wrote in message news:ehIWCmpaEHA.4048@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> how I can setup a role, so that they can only create, drop stored
procedure,
> views and functions. and can't create triggers, tables or modify schema.
>
> Tim
>
>
how I can setup a role, so that they can only create, drop stored procedure,
views and functions. and can't create triggers, tables or modify schema.
Tim
grant create procedure, create view, create function to <login>
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"t" <t@.t.t> wrote in message news:ehIWCmpaEHA.4048@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> how I can setup a role, so that they can only create, drop stored
procedure,
> views and functions. and can't create triggers, tables or modify schema.
>
> Tim
>
>
permissions
Hi All,
how I can setup a role, so that they can only create, drop stored procedure,
views and functions. and can't create triggers, tables or modify schema.
Tim
Hi,
You can only assign CREATE PROC, CREATE FUNCTION, CREATE VIEW to a
USER/ROLE. The DROP
permissons for any of this objects is not grantable.
Thanks
Hari
MCDBA
"t" <t@.t.t> wrote in message news:eXYPwlpaEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> how I can setup a role, so that they can only create, drop stored
procedure,
> views and functions. and can't create triggers, tables or modify schema.
>
> Tim
>
>
how I can setup a role, so that they can only create, drop stored procedure,
views and functions. and can't create triggers, tables or modify schema.
Tim
Hi,
You can only assign CREATE PROC, CREATE FUNCTION, CREATE VIEW to a
USER/ROLE. The DROP
permissons for any of this objects is not grantable.
Thanks
Hari
MCDBA
"t" <t@.t.t> wrote in message news:eXYPwlpaEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> how I can setup a role, so that they can only create, drop stored
procedure,
> views and functions. and can't create triggers, tables or modify schema.
>
> Tim
>
>
permissions
Hi All,
how I can setup a role, so that they can only create, drop stored procedure,
views and functions. and can't create triggers, tables or modify schema.
Timgrant create procedure, create view, create function to <login>
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"t" <t@.t.t> wrote in message news:ehIWCmpaEHA.4048@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> how I can setup a role, so that they can only create, drop stored
procedure,
> views and functions. and can't create triggers, tables or modify schema.
>
> Tim
>
>
how I can setup a role, so that they can only create, drop stored procedure,
views and functions. and can't create triggers, tables or modify schema.
Timgrant create procedure, create view, create function to <login>
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"t" <t@.t.t> wrote in message news:ehIWCmpaEHA.4048@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> how I can setup a role, so that they can only create, drop stored
procedure,
> views and functions. and can't create triggers, tables or modify schema.
>
> Tim
>
>
permissions
Hi All,
how I can setup a role, so that they can only create, drop stored procedure,
views and functions. and can't create triggers, tables or modify schema.
Timgrant create procedure, create view, create function to <login>
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"t" <t@.t.t> wrote in message news:ehIWCmpaEHA.4048@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> how I can setup a role, so that they can only create, drop stored
procedure,
> views and functions. and can't create triggers, tables or modify schema.
>
> Tim
>
>
how I can setup a role, so that they can only create, drop stored procedure,
views and functions. and can't create triggers, tables or modify schema.
Timgrant create procedure, create view, create function to <login>
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"t" <t@.t.t> wrote in message news:ehIWCmpaEHA.4048@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> how I can setup a role, so that they can only create, drop stored
procedure,
> views and functions. and can't create triggers, tables or modify schema.
>
> Tim
>
>
Subscribe to:
Posts (Atom)