Can you create a view from a stored procedure?

[johncasimir]

This is the problem.

I'm creating a crystal reports report and using a stored procedure to return the dataset.
However I need to implement the company's security which basically is written in visual basic by executing a script to destroy then recreate a View with the new security detail.
My idea is to have crystal execute a stored procedure which dumps the data into a table, then destroy and recreated a view with the new security to return the secured dataset to crystal?

Is this possible?

Thanks much for all of your expert help in advance!

 

[hneal98]

Why would you need to destroy and recreate a view?

 

[johncasimir]

Thanks for your reply.
I've solved the problem.
I was unclear as to how the clients' database was set up for report security.
The client's app automatically creates security conscious views of the base tables for reporting.
My solution is simple: I use those views instead of the base tables in my stored procedure to prepare the datasets needed for the reports.

 

[hneal98]

Good. That sounds better.