Accessing jobs in EM

Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
IgorThere is no supported way to do this with Enterprise
Manager. The proxy account doesn't really come in to play
here. The system stored procedures involved in displaying
the job info in Enterprise Manager have checks for job owner
or sysadmin server role membership.
-Sue
On Fri, 21 Jan 2005 14:46:12 -0800, "Igor Marchenko"
<igormarchenko@.hotmail.com> wrote:

>Hello!
>
> I would like to allow non-admin users seeing all jobs (including ones
>they do now own) in Enterpise Manager.SQL Profiler displays execution of
>exec msdb..sp_help_job when querying job list. According to BOL: ' A user
>who is not a member of the sysadmin fixed role can use sp_help_job to view
>only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't b
e
>of any help in this case. Is this possible for non-admin users to see all
>jobs?
>
>Thanks,
>Igor
>|||Thanks,Sue. I have found another way:
1.. Grant access to MSDB
2.. Add users to the member of TargetServerRole.
Regards,
Igor
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:lvnav0d2r3c3n64s620e9me5o0o7t1pdl6@.
4ax.com...
> There is no supported way to do this with Enterprise
> Manager. The proxy account doesn't really come in to play
> here. The system stored procedures involved in displaying
> the job info in Enterprise Manager have checks for job owner
> or sysadmin server role membership.
> -Sue
> On Fri, 21 Jan 2005 14:46:12 -0800, "Igor Marchenko"
> <igormarchenko@.hotmail.com> wrote:
>
>|||Okay but just remember it's not supported though and how
this works with this role depends on what service pack you
are on.
-Sue
On Tue, 25 Jan 2005 10:39:09 -0800, "Igor Marchenko"
<igormarchenko@.hotmail.com> wrote:

>Thanks,Sue. I have found another way:
> 1.. Grant access to MSDB
> 2.. Add users to the member of TargetServerRole.
>Regards,
>Igor
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:lvnav0d2r3c3n64s620e9me5o0o7t1pdl6@.
4ax.com...
>|||Thanks a lot,Sue.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5f5dv0d14fq7ajas3r6qq577is20d0gn57@.
4ax.com...
> Okay but just remember it's not supported though and how
> this works with this role depends on what service pack you
> are on.
> -Sue
> On Tue, 25 Jan 2005 10:39:09 -0800, "Igor Marchenko"
> <igormarchenko@.hotmail.com> wrote:
>
>

Accessing Database Users

Hi,

I would like to know if there is any way of Accessing database users from frontend and changing their persmissions.

Thanks

Niranjana.

You can do it from Enterprise Manager. Anything other than that you can run profiler and see what procs get called and build your own tool simulating the windows from EM.

|||

Thanks for the idea!

Let me try...

-Niranjana.

|||

Hi Dinakar,

Your idea worked fine...Thank you

-Niranch

|||

Hi dinakar,

I am trying to pull the users for a database and display in the frontend. As by your idea I have found the storedprocedure which displays the users in the Enterprise Mangager. This Stored Procedure Stores the values of all users in a temp table.

Can you please let me know,

How to get output from temp tables? used in the procedure...

thanks

-Niranch

|||

Check out master..syslogins.

|||

I have located the system stored procedure(sp_MSdbuseraccess) which will list all the users of the database. Now my question is, how to get the output values from the stored procedure...so that i can use it from the front end...

thanks

-niranch

|||Well you could cut n paste the code into your own proc and call the proc from your application.|||

Cutting and pasting will not help, since the stored procedure doesn't give any output, it is a system stored procedure which just collects the loginid's and the permission level and displays these details in the Enterprise manager(I guess it has it's own logic to display in the EM).Anyhow it stores the output value in a TEMP Table.

In my case, I want to use this proc to get the login id's and display in the front end. I could get the values from the TEMP table, I would like to know how to retrieve the values of the temp table outside the procedure? If it is not possible is there anyother way of converting these TEMP table values to recordsets and send it as OUTPUT values? Kindly help me...

Thanks

-Niranch

|||If temp table is not an option you could create a physical table and insert into it and later do a SELECT from the table outside the proc.|||

Thank You, Let me try that....

-Niranch

Accessing an LDF file

I need to "browse" a 2GB SQL Server Transaction Log (.ldf file) to see if I
can extract certain information about a users activity. What can I use to
brows this file?
Thanks - Seanthree words "lumigent log explorer", is a thid party tool tha can explore th
e sql server transaction log, creating a audit solution, besides, you can ge
nerate the rollback statements for an specific transaction, and many more.
http://www.lumigent.com/
enjoy it
"HelpPls" wrote:

> I need to "browse" a 2GB SQL Server Transaction Log (.ldf file) to see if
I
> can extract certain information about a users activity. What can I use to
> brows this file?
> Thanks - Sean
>
>

Access to tables SQL Server 2005

Hello!

I have a application where users are supposed to edit data from a table in a datagrid.

I want to use a dropdownlist to let the user choose a table to edit.

The users are members of different windows-goupes and different users have only access to edit there own tables. Let's say that they own data in different tables.

Is it possible to use windows authentication to find out what tables to show in the dropdownlist?

If it is, how do I get the names of the tables?

Best regards

Per

This query 'should' provide a list of ONLY the tables whereon the user has at least SELECT permission.

Code Snippet

SELECT TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

|||

Thank you!

That is very useful.

//P

access to sqlserver database from web

Hi
I do not want to install SQL server client on every user machine.
I want to give users access from browser to the sqlserver 2000 database.
Is it possible?
I saw sqlserver webadministrator?
From the name it looks like a administration tool?
Thanks
Mangesh
"SQL Server Web Data Administrator"
http://www.microsoft.com/downloads/d...displaylang=en
Cristian Lefter, SQL Server MVP
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:8B328C00-790E-4FD0-82F3-022F3C6ABA40@.microsoft.com...
> Hi
> I do not want to install SQL server client on every user machine.
> I want to give users access from browser to the sqlserver 2000 database.
> Is it possible?
> I saw sqlserver webadministrator?
> From the name it looks like a administration tool?
> Thanks
> Mangesh

access to sqlserver database from web

Hi
I do not want to install SQL server client on every user machine.
I want to give users access from browser to the sqlserver 2000 database.
Is it possible?
I saw sqlserver webadministrator?
From the name it looks like a administration tool'
Thanks
Mangesh"SQL Server Web Data Administrator"
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
Cristian Lefter, SQL Server MVP
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:8B328C00-790E-4FD0-82F3-022F3C6ABA40@.microsoft.com...
> Hi
> I do not want to install SQL server client on every user machine.
> I want to give users access from browser to the sqlserver 2000 database.
> Is it possible?
> I saw sqlserver webadministrator?
> From the name it looks like a administration tool'
> Thanks
> Mangesh

access to sqlserver database from web

Hi
I do not want to install SQL server client on every user machine.
I want to give users access from browser to the sqlserver 2000 database.
Is it possible?
I saw sqlserver webadministrator?
From the name it looks like a administration tool'
Thanks
Mangesh"SQL Server Web Data Administrator"
http://www.microsoft.com/downloads/...&displaylang=en
Cristian Lefter, SQL Server MVP
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:8B328C00-790E-4FD0-82F3-022F3C6ABA40@.microsoft.com...
> Hi
> I do not want to install SQL server client on every user machine.
> I want to give users access from browser to the sqlserver 2000 database.
> Is it possible?
> I saw sqlserver webadministrator?
> From the name it looks like a administration tool'
> Thanks
> Mangesh

Access to SQL

I have some users that use an access database to (believe it or not) store
some data in.
I was wondering if there is a way to import this access file into SQL and
still be able to allow the users access to it to be able to enter in data?
Thanks.
"johnfli" <john@.here.com> wrote in message
news:uaaXmBadEHA.3316@.TK2MSFTNGP10.phx.gbl...
> I have some users that use an access database to (believe it or not) store
> some data in.
> I was wondering if there is a way to import this access file into SQL and
> still be able to allow the users access to it to be able to enter in data?
You can import (or export) individual tables from Access into SQL Server.
In the most basic configuration you could link your SQL Server tables from
Access and allow users the ability to manipulate data. This solution would
not be that scalable. A code based solution would scale much better.
Steve
|||The main reason why I was looking to move it over to SQL was because I am
not using SQL but have all the licenses for it. I only have a few for
Access and would rather use SQL than buy more licenses as they decide to add
more people.
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:OaCQ8JadEHA.3076@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> "johnfli" <john@.here.com> wrote in message
> news:uaaXmBadEHA.3316@.TK2MSFTNGP10.phx.gbl...
store[vbcol=seagreen]
and[vbcol=seagreen]
data?
> You can import (or export) individual tables from Access into SQL Server.
> In the most basic configuration you could link your SQL Server tables from
> Access and allow users the ability to manipulate data. This solution would
> not be that scalable. A code based solution would scale much better.
> Steve
>
|||You can use the Access Upsizing Wizard, which is free on MS web site
somewhere... It does not do the greatest job at picking data types and
lengths, nor does it bring across stored queries...
At better method would be to use DTS in SQL Enterprise Manager to port the
data over...
DTS is documented in Books On Line.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"johnfli" <john@.here.com> wrote in message
news:uaaXmBadEHA.3316@.TK2MSFTNGP10.phx.gbl...
> I have some users that use an access database to (believe it or not) store
> some data in.
> I was wondering if there is a way to import this access file into SQL and
> still be able to allow the users access to it to be able to enter in data?
> Thanks.
>

Access to SQL

I have some users that use an access database to (believe it or not) store
some data in.
I was wondering if there is a way to import this access file into SQL and
still be able to allow the users access to it to be able to enter in data?
Thanks."johnfli" <john@.here.com> wrote in message
news:uaaXmBadEHA.3316@.TK2MSFTNGP10.phx.gbl...
> I have some users that use an access database to (believe it or not) store
> some data in.
> I was wondering if there is a way to import this access file into SQL and
> still be able to allow the users access to it to be able to enter in data?
You can import (or export) individual tables from Access into SQL Server.
In the most basic configuration you could link your SQL Server tables from
Access and allow users the ability to manipulate data. This solution would
not be that scalable. A code based solution would scale much better.
Steve|||The main reason why I was looking to move it over to SQL was because I am
not using SQL but have all the licenses for it. I only have a few for
Access and would rather use SQL than buy more licenses as they decide to add
more people.
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:OaCQ8JadEHA.3076@.TK2MSFTNGP10.phx.gbl...
> "johnfli" <john@.here.com> wrote in message
> news:uaaXmBadEHA.3316@.TK2MSFTNGP10.phx.gbl...
> > I have some users that use an access database to (believe it or not)
store
> > some data in.
> >
> > I was wondering if there is a way to import this access file into SQL
and
> > still be able to allow the users access to it to be able to enter in
data?
> You can import (or export) individual tables from Access into SQL Server.
> In the most basic configuration you could link your SQL Server tables from
> Access and allow users the ability to manipulate data. This solution would
> not be that scalable. A code based solution would scale much better.
> Steve
>|||You can use the Access Upsizing Wizard, which is free on MS web site
somewhere... It does not do the greatest job at picking data types and
lengths, nor does it bring across stored queries...
At better method would be to use DTS in SQL Enterprise Manager to port the
data over...
DTS is documented in Books On Line.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"johnfli" <john@.here.com> wrote in message
news:uaaXmBadEHA.3316@.TK2MSFTNGP10.phx.gbl...
> I have some users that use an access database to (believe it or not) store
> some data in.
> I was wondering if there is a way to import this access file into SQL and
> still be able to allow the users access to it to be able to enter in data?
> Thanks.
>

Access to SQL

I have some users that use an access database to (believe it or not) store
some data in.
I was wondering if there is a way to import this access file into SQL and
still be able to allow the users access to it to be able to enter in data?
Thanks."johnfli" <john@.here.com> wrote in message
news:uaaXmBadEHA.3316@.TK2MSFTNGP10.phx.gbl...
> I have some users that use an access database to (believe it or not) store
> some data in.
> I was wondering if there is a way to import this access file into SQL and
> still be able to allow the users access to it to be able to enter in data?
You can import (or export) individual tables from Access into SQL Server.
In the most basic configuration you could link your SQL Server tables from
Access and allow users the ability to manipulate data. This solution would
not be that scalable. A code based solution would scale much better.
Steve|||The main reason why I was looking to move it over to SQL was because I am
not using SQL but have all the licenses for it. I only have a few for
Access and would rather use SQL than buy more licenses as they decide to add
more people.
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:OaCQ8JadEHA.3076@.TK2MSFTNGP10.phx.gbl...
> "johnfli" <john@.here.com> wrote in message
> news:uaaXmBadEHA.3316@.TK2MSFTNGP10.phx.gbl...
store[vbcol=seagreen]
and[vbcol=seagreen]
data?[vbcol=seagreen]
> You can import (or export) individual tables from Access into SQL Server.
> In the most basic configuration you could link your SQL Server tables from
> Access and allow users the ability to manipulate data. This solution would
> not be that scalable. A code based solution would scale much better.
> Steve
>|||You can use the Access Upsizing Wizard, which is free on MS web site
somewhere... It does not do the greatest job at picking data types and
lengths, nor does it bring across stored queries...
At better method would be to use DTS in SQL Enterprise Manager to port the
data over...
DTS is documented in Books On Line.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"johnfli" <john@.here.com> wrote in message
news:uaaXmBadEHA.3316@.TK2MSFTNGP10.phx.gbl...
> I have some users that use an access database to (believe it or not) store
> some data in.
> I was wondering if there is a way to import this access file into SQL and
> still be able to allow the users access to it to be able to enter in data?
> Thanks.
>

Access to Reports

Sorry for the newbie question. I have a need to share reports with non-Crystal users. I'd like for recipients to be able to access reports and refresh the data. Is is possible via web or a reader if the recipients don't have access to the databases? Or, is there automation contained with CR that will generate a report and email it on a schedule?

I don't have development resources to custom build anything (i.e. web portal). Any solution would have to be an add-on to Crystal or off-the-shelf. Thank you for your suggestions.I have found that when using crystal to report off a sql database that users must be given at leat read write permission within the sql database, and in our case a viewer needed to be loaded on the client terminal to see the report.

Access to execute Store procedures

Hello there
I would like to give my users permission to insert/update/delete data
from/to tables and views
and i also need to give them full access to execute Store Procedures.
In order to do so i gave them on Dababase mode db_datareader and
db_datawriter roles.
This roles are giving them full access to insert/update and delete data, but
it doesn't give them access to execute Store procedures.
Which permission i sould give them wituout give them db_owner?Roy
GRANT EXECUTE ON storeprocedure TO username
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:eNhG2daLHHA.4376@.TK2MSFTNGP03.phx.gbl...
> Hello there
> I would like to give my users permission to insert/update/delete data
> from/to tables and views
> and i also need to give them full access to execute Store Procedures.
> In order to do so i gave them on Dababase mode db_datareader and
> db_datawriter roles.
> This roles are giving them full access to insert/update and delete data,
> but it doesn't give them access to execute Store procedures.
> Which permission i sould give them wituout give them db_owner?
>|||Shalom Uri
This i've already know
I'm looking for role for this and not go spesific on each store procedure.
on the business i'm working on they are afraid to give the users db_owner's
permission which i know that it is not a problem.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O%23XjUuaLHHA.1280@.TK2MSFTNGP04.phx.gbl...
> Roy
> GRANT EXECUTE ON storeprocedure TO username
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:eNhG2daLHHA.4376@.TK2MSFTNGP03.phx.gbl...
>|||Roy
Ok, so create a new role, add to the role users that you want to execute
sp. Go to the permission tab and click/check EXEC column for stored
procedure
Also , you can write script to grant an execute permission for all stored
procedure tospecific user. If you are interested I will post it out
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:uW%23ObyaLHHA.4244@.TK2MSFTNGP04.phx.gbl...
> Shalom Uri
> This i've already know
> I'm looking for role for this and not go spesific on each store procedure.
> on the business i'm working on they are afraid to give the users
> db_owner's permission which i know that it is not a problem.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:O%23XjUuaLHHA.1280@.TK2MSFTNGP04.phx.gbl...
>|||Roy
Be aware that if you have dymanic sql within a stored procedure you will
have to grant SELECT/UPDATE/INSERT/DELETE permission on underlaying table
as well
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u$6IH4aLHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Roy
> Ok, so create a new role, add to the role users that you want to execute
> sp. Go to the permission tab and click/check EXEC column for stored
> procedure
> Also , you can write script to grant an execute permission for all stored
> procedure tospecific user. If you are interested I will post it out
>
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:uW%23ObyaLHHA.4244@.TK2MSFTNGP04.phx.gbl...
>|||Whell Uri
For this i have already gave db_datareader and db_datawriter role which
supply this need.
In fact before i deal there, it was as you said.
Now after i add db_datareader and db_datawriter this problem has gone and
there is full permission
it is seems to be some stupide of microsoft not to have role to execute
store procedures. it looks like the is reason for it. i'm wondering why
thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23ed005aLHHA.3268@.TK2MSFTNGP04.phx.gbl...
> Roy
> Be aware that if you have dymanic sql within a stored procedure you will
> have to grant SELECT/UPDATE/INSERT/DELETE permission on underlaying table
> as well
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:u$6IH4aLHHA.2456@.TK2MSFTNGP06.phx.gbl...
>|||Roy Goldhammer (roy@.hotmail.com) writes:
> For this i have already gave db_datareader and db_datawriter role which
> supply this need.
> In fact before i deal there, it was as you said.
> Now after i add db_datareader and db_datawriter this problem has gone and
> there is full permission
> it is seems to be some stupide of microsoft not to have role to execute
> store procedures. it looks like the is reason for it. i'm wondering why
You can't do this in SQL 2000, as far as I know. But in SQL 2005,
permissions cascade, and you can say things like:
grant execute on database::yourdb to somerole
grant execute on schema::dbo to someotherrole
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Access to another database via a stored procedure

I have a stored procedure on a database that selects information from
another database, and the users running the stored procedure are not users
on the 2nd database. I don't want to have to enter all users individually
into the 2nd database, I just want anyone who has execute rights to that
stored procedure to be able to select information from the 2nd database.
Do I have to somehow in the stored procedure log into the 2nd database as a
public user?
Right now I am getting errors that says the user is not a user of the 2nd
database. The 2nd database is a public database, so I shouldn't need to be
a user on it.Users need a security context in all databases accessed. If you don't want
to add users to the 2nd database, one method:
1) enable the 'guest' user in the second database (sp_adduser 'guest')
2) enable 'db chaining on both databases (sp_dboption 'DB2', 'db chaining',
true)
If you objects are objects are owned by 'dbo', both databases need to have
the same owner so that the dbo user ownership chain is unbroken. You can
execute sp_changedbowner, if necessary. No permissions need be granted to
guest. Guest permissions are limited to those granted to public.
Note that you should fully trust those users that can create dbo-owned
objects before you enable cross-database chaining ('db chaining'). If the
databases are owned by 'sa', ensure only symin role members should have
permissions to create db-owned objects.
Hope this helps.
Dan Guzman
SQL Server MVP
"et" <eagletender2001@.yahoo.com> wrote in message
news:eO3CPC1AGHA.4080@.TK2MSFTNGP14.phx.gbl...
>I have a stored procedure on a database that selects information from
>another database, and the users running the stored procedure are not users
>on the 2nd database. I don't want to have to enter all users individually
>into the 2nd database, I just want anyone who has execute rights to that
>stored procedure to be able to select information from the 2nd database. Do
>I have to somehow in the stored procedure log into the 2nd database as a
>public user?
> Right now I am getting errors that says the user is not a user of the 2nd
> database. The 2nd database is a public database, so I shouldn't need to
> be a user on it.
>|||Thanks so much, this is very helpful information. I think the guest account
will work just fine, as I agree that I don't think I want to do the cross
ownership until I see the need. Thanks.
Thanks!
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OsaivR1AGHA.2512@.TK2MSFTNGP09.phx.gbl...
> Users need a security context in all databases accessed. If you don't
> want to add users to the 2nd database, one method:
> 1) enable the 'guest' user in the second database (sp_adduser 'guest')
> 2) enable 'db chaining on both databases (sp_dboption 'DB2', 'db
> chaining', true)
> If you objects are objects are owned by 'dbo', both databases need to have
> the same owner so that the dbo user ownership chain is unbroken. You can
> execute sp_changedbowner, if necessary. No permissions need be granted to
> guest. Guest permissions are limited to those granted to public.
> Note that you should fully trust those users that can create dbo-owned
> objects before you enable cross-database chaining ('db chaining'). If the
> databases are owned by 'sa', ensure only symin role members should have
> permissions to create db-owned objects.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "et" <eagletender2001@.yahoo.com> wrote in message
> news:eO3CPC1AGHA.4080@.TK2MSFTNGP14.phx.gbl...
>|||I'm glad you found the information useful.
Just to be clear, if you don't enable cross database chaining, you will then
need to grant SELECT permissions to guest (or public) in the second database
because the ownership chain is broken. This will effectively allow all
server users not already in the second database to select from the table
directly. This might be ok in your situation but I want to make sure you
are aware of the ramifications.
Hope this helps.
Dan Guzman
SQL Server MVP
"et" <eagletender2001@.yahoo.com> wrote in message
news:uh%23icI2AGHA.2788@.TK2MSFTNGP14.phx.gbl...
> Thanks so much, this is very helpful information. I think the guest
> account will work just fine, as I agree that I don't think I want to do
> the cross ownership until I see the need. Thanks.
> Thanks!
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:OsaivR1AGHA.2512@.TK2MSFTNGP09.phx.gbl...
>

access rs reports through .aspx

I'm not sure of what i should do to come up with a web site that allows the
users to access the reports that are in my reportserver, I would like to
know a step by step instructions on how to access my reports using asp.net
web application.
Is my problem has anything to do with configuring consoles or xml log files?
Will I have to make a coding that will look for server/ virtualroot/
pathinfo prefixes.. and where and how will i make one?
I am really confused on which or what should i do to access my reports
through aspx application ..
Please guide me..
--
~SiMPLe~You need to decide if you are going to integrate using URL integration
(easiest and fullest featured) or web services (harder but complete
control). Is this an intranet or internet. If internet where you don't want
the user to have access to your server then you would have to use web
services. If URL integration then the best thing is to first understand the
URL that you need to create. Make sure you can create the URL (even just
typing it in from IE) and that you can pass parameters. Once you can do that
then you can control the other aspects of it. I tend to create the URL for
Jump to URL which is a little different (RS automatically fills in the
server name so I don't have to deal with it).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alex" <alex@.interpac.com.ph(donotspam)> wrote in message
news:C9A32654-7806-402D-B709-9D7289DC9889@.microsoft.com...
> I'm not sure of what i should do to come up with a web site that allows
> the
> users to access the reports that are in my reportserver, I would like to
> know a step by step instructions on how to access my reports using asp.net
> web application.
> Is my problem has anything to do with configuring consoles or xml log
> files?
> Will I have to make a coding that will look for server/ virtualroot/
> pathinfo prefixes.. and where and how will i make one?
> I am really confused on which or what should i do to access my reports
> through aspx application ..
> Please guide me..
> --
> ~SiMPLe~|||so i need to know how to intergrate my reports using web services.. because i
don't want my clients to see my server.. Can you tell me in details how
should i start making one? and also in the URL integration, you mean the
prefixes right? (rs.. rc.. ) I guess i'll also use the URL integration
inside my web service?
--
~SiMPLe~
"Bruce L-C [MVP]" wrote:
> You need to decide if you are going to integrate using URL integration
> (easiest and fullest featured) or web services (harder but complete
> control). Is this an intranet or internet. If internet where you don't want
> the user to have access to your server then you would have to use web
> services. If URL integration then the best thing is to first understand the
> URL that you need to create. Make sure you can create the URL (even just
> typing it in from IE) and that you can pass parameters. Once you can do that
> then you can control the other aspects of it. I tend to create the URL for
> Jump to URL which is a little different (RS automatically fills in the
> server name so I don't have to deal with it).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Alex" <alex@.interpac.com.ph(donotspam)> wrote in message
> news:C9A32654-7806-402D-B709-9D7289DC9889@.microsoft.com...
> > I'm not sure of what i should do to come up with a web site that allows
> > the
> > users to access the reports that are in my reportserver, I would like to
> > know a step by step instructions on how to access my reports using asp.net
> > web application.
> > Is my problem has anything to do with configuring consoles or xml log
> > files?
> > Will I have to make a coding that will look for server/ virtualroot/
> > pathinfo prefixes.. and where and how will i make one?
> > I am really confused on which or what should i do to access my reports
> > through aspx application ..
> > Please guide me..
> >
> > --
> > ~SiMPLe~
>
>

access rights - dynamic reports

hi,
is it possible to make "dynamic reports" for users with different user
rights. depending on their rights one user sees all the columns and
another one with less rights sees just the first column?
thanksthere probably is ... but since i can't tell you i'll give you an
alternative solution - why don't you just create 2 reports
one for general users containing data that general people can see
one for 'special' users containing all of the 'secret' data. because
more than likely once the 'special' users see what they can get,
they're going to want more and it'd be easier to manage the reports on
a group basis rather than a more granular column by column basis.
those are my thoughts anyway ...
hth!

access rights

Hi,
I have many users and many databases in my Server 2000 installation. Each
user has only one database (with owner permission) and each database has one
owner. With mylittleadmin, I have no problems, each user can only see their
own database (which they have owner permisssion). But with web data
administrator, they can also see master and some other system databases
since they have guest permission. When one of these users connects the
server with enterprise management, things get worse. Users see ALL databases
eventhough they cannot reach them. I want users to see only their own
databases, not anobody elses. They cannot access the other databases, this
is ok but the other databases should not be listed as well. How can i solve
this?
Thanks.In Enterprise Manager you can't (in a supported way), they will always see
all the database names. This is being addressed in SQL2005's Management
Studio IIRC.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Sfrnc Murat" <@.> wrote in message
news:%23RYBX2Z8EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have many users and many databases in my Server 2000 installation. Each
> user has only one database (with owner permission) and each database has
> one
> owner. With mylittleadmin, I have no problems, each user can only see
> their
> own database (which they have owner permisssion). But with web data
> administrator, they can also see master and some other system databases
> since they have guest permission. When one of these users connects the
> server with enterprise management, things get worse. Users see ALL
> databases
> eventhough they cannot reach them. I want users to see only their own
> databases, not anobody elses. They cannot access the other databases, this
> is ok but the other databases should not be listed as well. How can i
> solve
> this?
>
> Thanks.
>

Access right for Database Role

Hi,
For database users assigned with database role "db_datareader" and "Public".
Does it mean that he / she is able to browse all tables and execute Stored
Procedures. OR He / She can only execute Stored Procedures ?
If we want to give him / her access right to exec Stored Procedures only,
which database role should be assigned to him / her ?
Thanks
the db_datareader role only allows the user to read tables in the database,
not exec stored procedures. There is no role that grants exec permissions on
all stored procs inside a db. You will have to manually grant them. See if
this helps:
http://vyaskn.tripod.com/generate_sc..._sql_tasks.htm
I have an example at the above link.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:ORyFIPKTFHA.3056@.TK2MSFTNGP14.phx.gbl...
Hi,
For database users assigned with database role "db_datareader" and "Public".
Does it mean that he / she is able to browse all tables and execute Stored
Procedures. OR He / She can only execute Stored Procedures ?
If we want to give him / her access right to exec Stored Procedures only,
which database role should be assigned to him / her ?
Thanks

Access right for Database Role

Hi,
For database users assigned with database role "db_datareader" and "Public".
Does it mean that he / she is able to browse all tables and execute Stored
Procedures. OR He / She can only execute Stored Procedures ?
If we want to give him / her access right to exec Stored Procedures only,
which database role should be assigned to him / her ?
Thanksthe db_datareader role only allows the user to read tables in the database,
not exec stored procedures. There is no role that grants exec permissions on
all stored procs inside a db. You will have to manually grant them. See if
this helps:
http://vyaskn.tripod.com/generate_scripts_repetitive_sql_tasks.htm
I have an example at the above link.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:ORyFIPKTFHA.3056@.TK2MSFTNGP14.phx.gbl...
Hi,
For database users assigned with database role "db_datareader" and "Public".
Does it mean that he / she is able to browse all tables and execute Stored
Procedures. OR He / She can only execute Stored Procedures ?
If we want to give him / her access right to exec Stored Procedures only,
which database role should be assigned to him / her ?
Thanks

Access right for Database Role

Hi,
For database users assigned with database role "db_datareader" and "Public".
Does it mean that he / she is able to browse all tables and execute Stored
Procedures. OR He / She can only execute Stored Procedures ?
If we want to give him / her access right to exec Stored Procedures only,
which database role should be assigned to him / her ?
Thanksthe db_datareader role only allows the user to read tables in the database,
not exec stored procedures. There is no role that grants exec permissions on
all stored procs inside a db. You will have to manually grant them. See if
this helps:
http://vyaskn.tripod.com/generate_s...e_sql_tasks.htm
I have an example at the above link.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:ORyFIPKTFHA.3056@.TK2MSFTNGP14.phx.gbl...
Hi,
For database users assigned with database role "db_datareader" and "Public".
Does it mean that he / she is able to browse all tables and execute Stored
Procedures. OR He / She can only execute Stored Procedures ?
If we want to give him / her access right to exec Stored Procedures only,
which database role should be assigned to him / her ?
Thanks

Access queries using up space on server's C: drive

I have users who are running large SELECT type queries in Access against
a SQL Server via ODBC. What happens is that the c:\documents and
settings\<username>\Local Settings\Temp on the SQL server itself gets filled
until the drive starts running low on space. Other than to free up space on
the server's C: drive, are there any good suggestions to redirecting where
Access stores the temp files?

*************************************************
Andy S.
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
*************************************************
yeah
use access data projects instead and keep all your temp tables on the
db server.. where they belong (and have a good io system on the server)
|||Who's profile "<username>" ? And \temp dir gets filled up with what?
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Andy S." wrote:
| I have users who are running large SELECT type queries in Access
against
| a SQL Server via ODBC. What happens is that the c:\documents and
| settings\<username>\Local Settings\Temp on the SQL server itself gets
filled
| until the drive starts running low on space. Other than to free up space
on
| the server's C: drive, are there any good suggestions to redirecting where
| Access stores the temp files?
|
|
| --
|
| *************************************************
| Andy S.
| andymcdba1@.noreply.yahoo.com
|
| Please remove "noreply" before replying.
|
| *************************************************
|
|
|||Unfortunately, the end users are creating the queries. I wish I could have
coded everything myself, but that isn't an option. I'm thinking of even
trying to redirect the ODBC log directory setting, but I was hoping there
might be other ideas.
I'd actually rather keep all the temp files locally on the clients where
there is plenty of room.
<dbahooker@.hotmail.com> wrote in message
news:1128027434.706417.58830@.g49g2000cwa.googlegro ups.com...
> yeah
> use access data projects instead and keep all your temp tables on the
> db server.. where they belong (and have a good io system on the server)
>
|||end users CAN create queries in Access Data Projects on the SQL Server
side.. just as easily as on the Access side almost
stored procs are a lot more fun that mdb
|||username would be the end user's profile. I'm not sure of the file
extension, but it is a single large temp file that can grow several hundred
MB in size. I think it is from the ODBC setting for saving long running
queries to a particular folder. I'm not sure why it wouldn't be on the
workstation vs. the server.
"Dave Patrick" <DSPatrick@.nOsPAM.gmail.com> wrote in message
news:ermq9mTxFHA.3740@.tk2msftngp13.phx.gbl...
> Who's profile "<username>" ? And \temp dir gets filled up with what?
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Andy S." wrote:
> | I have users who are running large SELECT type queries in Access
> against
> | a SQL Server via ODBC. What happens is that the c:\documents and
> | settings\<username>\Local Settings\Temp on the SQL server itself gets
> filled
> | until the drive starts running low on space. Other than to free up
> space
> on
> | the server's C: drive, are there any good suggestions to redirecting
> where
> | Access stores the temp files?
> |
> |
> | --
> |
> | *************************************************
> | Andy S.
> | andymcdba1@.noreply.yahoo.com
> |
> | Please remove "noreply" before replying.
> |
> | *************************************************
> |
> |
>
|||How did the user profile folders on the SQL server come about? Do they
terminal service into the box? Some details of the files and or file types
may help. I've been running this scenario for a long time and never seen
this before.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Andy S." wrote:
| username would be the end user's profile. I'm not sure of the file
| extension, but it is a single large temp file that can grow several
hundred
| MB in size. I think it is from the ODBC setting for saving long running
| queries to a particular folder. I'm not sure why it wouldn't be on the
| workstation vs. the server.
|||why would you ever make a temp file that is hundreds of mb in size?
use some views man