hi all
I just want to know that how do i find which users have create objects privilages. As by sp_helpprotect<object_name> we can only know about the permissions on a particular object.But how do i know which users have which create objects permissions.
Plz let me know
thanks in advance for the help

Hi,

You can look into the sysprotects table using the uid of the user. The action column has a code you can also look for (198 for create table).

Philippe

Thanks a lot