SQL Server Performance Forum – Threads Archive
SQL ProfilerI need to create the login which should should server only for SQL Profiler. It should not have any permission like create database,create tabel,alter proc or alter table or Drop. i.e user mapped to the login should not have any permission on any of the objects. can i create the login and user for this sceniro?.Please help me ASAP. Regards
The workaround is to grant permission to that user to execute extended stored procedure to run PROFILER as specified in this articlehttp://www.databasejournal.com/features/mssql/article.php/1440421 for information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
1. Create the user
2. Give him permissions of Public and db_datareader in desired database (from Enterprise Manager). Remove all other permissions HTH Harsh