Regarding Accessing on every objects within the sql 2005

Hi guys , can I know is that any way to set up some authentication for user access all the objects within the database after login successfully. For example, after access login into the database server and would like to click on certain database (eg : A) , then pop up the user access login page again. Thxcould you explain this a bit more, I did′n′t get your point from the explanation.

Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Sorry for the short explanation. Er... let me give a scenario. Once I open SQL management studio, there's a user login pop up window in order I able to access into my server. After login successfully,there are 3 database displays and stored in my servers ( Db A,B and C). When I want to click on the A database, then will pop up the user login window again for authorization. After that, if I want to choose a specific object (eg: Table 'Test') , then there's the use login window pop up again for authorization. At here, which means that authorization will show first before proceed any actions on any objects from the database in my server,.

So is there any possible to make such scenario? I'm just curious about it and would like to enhance my SQL security for my server and away from data thefting (For example, while away from the pc for a while and there's a staff come towards the pc for viewing and modifying the data). Thx for any assistance. Have a nice day.

From,

Hans

|||

Hi,

no SSMS does not have this functionality. once autenticated, permissions are checked upon access to the objects not prompting for any credentials again.

HTH, jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

You should lock your console when away from your machine.

Thanks
Laurentiu

|||Thx for the advise. Seems like SQL 2005 doesn't have ' Always prompt for username and password login ' feature which in SQL 2000 then.|||

There was no such feature in SQL Server 2000. Maybe you are referring to a client feature, in which case you should post your inquiry on the Tools forum.

Thanks
Laurentiu

Refresh report without accessing database

I have a need to refresh a report after applying a filter on the data that is displayed, without accessing the database.

The following example is a simplified version of the functionality I'm trying to accomplish. The first report displays Sales & Projection data for all products. On clicking a particular product in the header, the second report displays just that product and the total metrics. I have created an rdl file for both the reports and based on the parameters passed, it displays one or several products. My concern is that the report is having to access the AS cube every time a product is clicked. In the real report, it's taking minutes to get the data. Is there way I can get the report to refresh to apply the filter without accessing the database again? Thanks in advance...

Report-1

Product

A

B

C

Total

Sales

100

200

300

600

Projection

200

200

300

700

Total

300

400

600

1300

Report-2

A

Total

Sales

100

600

Projection

200

700

Total

300

1300

I assume you have the reports set to execute live. In this case, changing parameters effectively causes RS to throw away the original report and start from scratch when you change parameter values. You may want to consider using the Cached option, this will allow RS to use the same report snapshot for a given set of query parameters and minimize the # of calls you make to the underlying AS database.|||

exactly what I needed... Thanks John.

Refresh report without accessing database

I have a need to refresh a report after applying a filter on the data that is displayed, without accessing the database.

The following example is a simplified version of the functionality I'm trying to accomplish. The first report displays Sales & Projection data for all products. On clicking a particular product in the header, the second report displays just that product and the total metrics. I have created an rdl file for both the reports and based on the parameters passed, it displays one or several products. My concern is that the report is having to access the AS cube every time a product is clicked. In the real report, it's taking minutes to get the data. Is there way I can get the report to refresh to apply the filter without accessing the database again? Thanks in advance...

Report-1

Product

A

B

C

Total

Sales

100

200

300

600

Projection

200

200

300

700

Total

300

400

600

1300

Report-2

A

Total

Sales

100

600

Projection

200

700

Total

300

1300

I assume you have the reports set to execute live. In this case, changing parameters effectively causes RS to throw away the original report and start from scratch when you change parameter values. You may want to consider using the Cached option, this will allow RS to use the same report snapshot for a given set of query parameters and minimize the # of calls you make to the underlying AS database.|||

exactly what I needed... Thanks John.

reduced functionality with Web Services

I'm curious exactly what functionality is lost when you use the RS Web
Service rather than accessing the direct URL. We're evaluating RS vs Crystal
and specifically need XLS export functionality. Is this lost if you use the
RS Web Service? Is there a way to export to PDF, XLS, etc. and still use the
RS Web Service?
Regards,
David GardnerIf you render using the web service, you loose the nice html toolbar you
get with URL access:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_intro_0pr6.asp
You can pass a format string to the Render method of the web service. It
supports multiple formats (including Excel, PDF...)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_6x0z.asp
Make sure you have Reporting Services SP1 installed, as there were a number
of fixes to the rendering extensions included in that service pack.
--
Adrian M.
MCP
"David Gardner" <David.Gardner-Logan@.REMOVECAPSrrd.com> wrote in message
news:6CD498D5-ED27-4626-89CF-49DC8E61DAB6@.microsoft.com...
> I'm curious exactly what functionality is lost when you use the RS Web
> Service rather than accessing the direct URL. We're evaluating RS vs
> Crystal
> and specifically need XLS export functionality. Is this lost if you use
> the
> RS Web Service? Is there a way to export to PDF, XLS, etc. and still use
> the
> RS Web Service?
> Regards,
> David Gardner