New answers tagged

0

First of all these V$ views are public synonyms hence can be accessed by any user having appropriate privileges. Since these views are public we don’t need to prefixed with the SCHEMA name though these synonyms are owned by SYS. After altering session as alter session set current_schem=SYS objects are prefixed with specified schema name in the subsequent ...


1

You might be asking too broad of a question but if you wanted to have a user only have access to a table in SQL Server you could simply do a: --Create Server Level User USE [master] GO CREATE LOGIN [(UserName)] WITH PASSWORD=N'PutPasswordHere' DEFAULT_DATABASE=[DatabaseName] GO --Create DB Level Uesr use [DatabaseName] GO CREATE USER (username) FOR LOGIN (...


0

I find no MySQL functionality to achieve what you need, you have to create what you need. If you use a statement like: GRANT EXECUTE ON FUNCTION `yourdatabase`.`yourfunction` TO 'youruser'@'localhost'; will apply: 14.7.1.4 GRANT Syntax ... Important MySQL does not automatically revoke any privileges when you drop a database or table. ...


0

Normally MySQL refer host name instead IP address According to your requirement, Let's start by making a new user called "chaminda" within the MySQL shell: CREATE USER 'chaminda'@'%' IDENTIFIED BY 'password'; The first thing to do is to provide the user with necessary permission and here I have given all permission to the particular user. GRANT ALL ...


0

You could perform the pg_dump with the parameters --no-owner and --no-acl, so no permissions or links to any users are presents in the dump.


4

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

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 ...


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'...


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 ...


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 ...



Top 50 recent answers are included