Question : I am trying the query – GRANT SELECT ON company.*, school.*, onlineshop.* TO user1@localhost; To which I am […]
Tag: permissions
Collation conflict when running dynamic sql FOR XML PATH
Question : I am getting the following error message when running the query below: Cannot resolve the collation conflict between […]
DROP command denied to user ‘root’@’localhost’
Question : Okay. Apparently someone removed the DROP privilege from root (they have every other privilege granted), presumably to prevent […]
Login permissions outside of sa – SQL Server
Question : Where I’m at, our DBA team is split up into admins, BI, DEV. We are wanting to have […]
cross database trigger: server principal is not able to access the database under the current security context
Question : I have a two databases Source and Target hosted in the same SQL Server 2008 R2 instance. I […]
Restrict access to new database by default
Question : I am administering a Postgres server for students on a very basic database course. Students get there own […]
Executing sys.dm_fts_parser without sysadmin server role
Question : A web application needs to execute sys.dm_fts_parser to discover which words SQL Server Fulltext Search used to match […]
How to list the permissions on User-Defined Table Types?
Question : I am using some user-defined table types. They are very useful. you can see information about them by […]
Allow access to specific user only
Question : I have a database with an owner for it. My problem is that, though I have assigned a […]
In Postgresql, after pg_dump the access privileges on the database itself are not restored
Question : Suppose user foo owns a database gee, and user foo has granted user bar with all access privileges […]