New answers tagged privileges
You can use SQL Activity Monitor. This will show the current queries executing in your SQL Server instance with below details SPID Login Database Name Task State Command Application Wait time Host Name and many more under PROCESSES tab Also you can have a look on Resource waits Data File I/O Recent Expensive Queries
I think your problem boils down to a misalignment of grants. When you run this query SELECT COUNT(1) column_count FROM information_schema.columns WHERE table_schema='mysql' AND table_name='user'; You should the following number If you get 43, MySQL 5.6 If you get 42, MySQL 5.5 If you get 39, MySQL 5.1 If you get 37, MySQL 5.0 It simply means you ...
Create stored procedures that do these tasks for them - these can be set to execute as owner and the user account can just be granted execute rights on the stored procedures. It means they'll have to learn the interface to your stored procedures (so document them well or give them view definition rights to them also).
You cannot revoke privileges that are not granted. The table (not database) owner implicitly has full rights on the table. They cannot be revoked, except by changing the owner of the table. What you probably want to do is connect with a user other than the owner of the database/tables, and GRANT that user only the rights it should have over the table(s).
Top 50 recent answers are included