I have one report that I want to have the ability to use different stored
procedures...depending on the the user's criteria they want to see. Is there
an RS method that I can use to change the stored procedure that a report is
using at runtime, or is there a better way to do what I want to do?ALthough I have never tried this,,, you could create a single SP which calls
the other SPs based on the user... OR
in the data set you can put the T-SQL IF statement to choose the SP..
I suspect that the SPs need to return the same result sets however...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Mike Collins" wrote:
> I have one report that I want to have the ability to use different stored
> procedures...depending on the the user's criteria they want to see. Is there
> an RS method that I can use to change the stored procedure that a report is
> using at runtime, or is there a better way to do what I want to do?
Showing posts with label ability. Show all posts
Showing posts with label ability. Show all posts
Thursday, March 8, 2012
Wednesday, March 7, 2012
Changing Password
How can I assign a user the ability to change/reset password for users
assigned to one particular database only in EM. Example, Northwind is one of
the databases in my system; I want the user john to be responsible for
changing/resetting password for users with access to Northwind database only
and nothing else. Is this possible? If so, how do I do it?
Thanks
EmmaPasswords are assigned to logins which are at the server
level. And only sysadmins and securityadmins can execute
sp_password. But that's at a server level, not the database
level. So no, not if you want to restrict it to just one
database.
-Sue
On Tue, 27 Sep 2005 06:52:25 -0700, "Emma"
<Emma@.discussions.microsoft.com> wrote:
>How can I assign a user the ability to change/reset password for users
>assigned to one particular database only in EM. Example, Northwind is one o
f
>the databases in my system; I want the user john to be responsible for
>changing/resetting password for users with access to Northwind database onl
y
>and nothing else. Is this possible? If so, how do I do it?
>Thanks
>Emma
assigned to one particular database only in EM. Example, Northwind is one of
the databases in my system; I want the user john to be responsible for
changing/resetting password for users with access to Northwind database only
and nothing else. Is this possible? If so, how do I do it?
Thanks
EmmaPasswords are assigned to logins which are at the server
level. And only sysadmins and securityadmins can execute
sp_password. But that's at a server level, not the database
level. So no, not if you want to restrict it to just one
database.
-Sue
On Tue, 27 Sep 2005 06:52:25 -0700, "Emma"
<Emma@.discussions.microsoft.com> wrote:
>How can I assign a user the ability to change/reset password for users
>assigned to one particular database only in EM. Example, Northwind is one o
f
>the databases in my system; I want the user john to be responsible for
>changing/resetting password for users with access to Northwind database onl
y
>and nothing else. Is this possible? If so, how do I do it?
>Thanks
>Emma
Subscribe to:
Posts (Atom)