INNER JOIN sysusers ON sysobjects.uid = sysusers.uid */. is_disabled FROM sys.triggers WHERE parent_class_desc = 'OBJECT_OR_COLUMN' ORDER BY OBJECT_NAME(parent_id), Name

SELECT name FROM sysusers SELECT name FROM sys.procedures; -- with INFORMATION_SCHEMA

Schemas include default db_* , sys, information_schema and guest schemas. select as schema_name, s.schema_id, as schema_owner from sys.schemas s inner join sys.sysusers u.

SELECT * FROM information_schema.PROCESSLIST WHERE COMMAND != 'Sleep' AND TIME > 4. How many processes per user? SELECT SUBSTR(HOST, 1, LOCATE(':',HOST)-1) AS hostname, COUNT(*) FROM information_schema.PROCESSLIST GROUP BY hostname.

-- доменный юзер SELECT * FROM sys.sysusers --- 22 записи. Нету части моих датабазе ролей. в обычной не базе создайте бесправного юзера и убедитесь, что он прекрасно видит fixed database roles, если опрашивает sysusers

Page generated - 0.2588448524 (55c36b17045939fe4a93b371aaaf529d)