Hot answers tagged

5

There are multiple entries because you can be granted the same permission multiple times, from different "grantors". If that principal (i.e. the "grantee") were already granted that same permission from two grantors, then you would see three entries for that same permission on this screen. For the "duplicate" entries that you are seeing, the one with the ...


3

Is there anyway to tell up front whether the blanket grant has been applied? For the blanket grant I don't see any users set up under the Permissions page in SSMS for any of the SPs in question and yet it just works. Below is a TSQL method to find all explicit DB object permissions and members of fixed or custom DB roles per each DB you run it ...


2

Yes. Just add the CREATE privilege: GRANT CREATE ON `foobar%`.* TO 'foobaruser'@'%' IDENTIFIED BY 'foobarpass'; And just test it: foobaruser$ mysql mysql> create database `foobar_one`; Query OK, 1 row affected (0.00 sec) mysql> create database `barfoo_one`; ERROR 1044 (42000): Access denied for user 'foobaruser'@'localhost' to database 'barfoo_one'...


2

What is possible is what's specified in the documentation for GRANT (http://www.postgresql.org/docs/current/static/sql-grant.html). To make modifications on tables, a user must own the object. When a user owns an object, a user can do whatever they want with it (including restricting themselves any kind of access, along with the ability to grant themselves ...


1

The program which performs log shipping runs under a specific UserID. Assuming you are using SQL Server Agent to perform log shipping on a schedule, log shipping will happen using SQL Server Agent's credentials (but see below for proxy accounts). You can find this by starting SQL Server Configuration, highlighting SQL Server Services and right-clicking on ...



Only top voted, non community-wiki answers of a minimum length are eligible