Hi,
We have a database 'X' which is being accessed by a user 'ABC'. ABC has the following access:
db_datareader
db_datawriter
db_executor (a role I created, which has execute permissions on all SPs in the database)
In addition to the rights mentioned above, I would like to give debug permissions to 'ABC'. While implementing this, I do not want the user to have access to execute DDL statements and hence do not want to give any admin-level access.
How do I achieve this? Pls help!
Regards,
Guru