one of my application user asking to give access to execute a storedprocedure where ever he wants to execute in any database it it possible? if so how
wha permissions can we give inthis case ??
i feel it by giving [ddladmin and db_owner ] in database role and setupadmin and serveradmin in server role ??
is it possible to make a stored procedure to execute in any database ?