Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.

learn more… | top users | synonyms

1
vote
0answers
2k views

EXECUTE AS over Linked Servers

I have a front end that logs into the DB as "logInA", and only has permission to "schemaA" stored procs, which use EXECUTE AS "logInB", (I have also tried EXECUTE AS 'DBO'), to handle all the business ...
1
vote
2answers
1k views

Can I restore the defult SQL Server Public Role?

I setup a new user login and attached it to a specific database on my server. I then opened up management studio on my local pc, connected to the database using the server IP and selecting the ...
1
vote
2answers
69 views

Oracle: are objects created by sys in a schema the same as objects created by that user?

For example, are there any differences between: SCOTT@ORCL> create index a_idx on a(x); and SYS@ORCL> create index scott.a.idx on scott.a(x);
0
votes
4answers
4k views

Unable to access mysql database remotely

I ran this command- [root@dev-img mysql]# mysql -u root -h 192.168.1.181 -e "use mysql;" and this is the output I got- ERROR 1045 (28000): Access denied for user 'root'@'192.168.1.65' (using ...
0
votes
1answer
67 views

How can I give a group of developers the ability to view the query plan, without the ability to run a trace or to view the server state?

I have a group of 5 developers that need to be able to view the plans of queries they have written for a database, and that database only. I refuse to make them a member of sysadmin. I do not want ...
0
votes
1answer
128 views

How to deny access to see the logins in a database

I create a login in SQL Server 2008 R2, and when that user connects to a database, it can see all the logins in the security logins. Can I deny access to watch the logins of the database?
0
votes
1answer
162 views

What do columns with a “dot” mean when listing Sql Server user permissions using sp_helprotect?

I have a DB that I did not setup and I used sp_helprotect to list the permissions, the output is as in the image below. I don't understand the dot's in the Owner, Object and Column columns. And I ...
0
votes
2answers
96 views

Grant access on a database to all users

I have a global database, as I all users should have access to it. Is it possible to grant permission on a database to all users? something like GRANT ALL ON my_database.* TO *@localhost; Even (for ...
0
votes
1answer
1k views

Add user to sql server with the required permission

In my sql server express 2008 r2 i have about 15 login account. Now i want some about 5 users have full permission while some other 5 users with limited access to some database, and other users only ...
0
votes
1answer
347 views

How to troubleshoot/debug Oracle permission problems

An application is connecting to Oracle to do stuff. It's not working but I don't get any ORA errors in the application itself. I'm thinking its a permission problem. So my question is what is the best ...
0
votes
1answer
34 views

Allow public use of functions without giving them database control

I came up with a set of functions that I would like to be accessed from a variety of places. SQL seemed like the best place for this due to accessibility, but I receive this error when trying to use ...
0
votes
1answer
49 views

How to become an administrator for SQL Server

Here is the situation: I Installed VS2013 That comes with SQL Server Express I am not able to create a DB from VS2013 thinking that it's because of user privilege issues, I Installed SQL Server ...
0
votes
2answers
277 views

How to save and then restore permissions after refreshing a database

A database in a STAGING environment is overwritten every N weeks with a PRODUCTION copy that is more recent. What is the proper way to save and then restore users, roles and explicitly granted ...
0
votes
1answer
108 views

SQL Server 2012: stored procedures permissions

Is it possible to control permissions on a single stored procedure level in SQL Server 2012? It seems that SQL Server Manager doesn't expose such functionality via GUI. Can somebody advice me how to ...
0
votes
1answer
146 views

What is the meaning of different roles available(DB Admin etc.)

I have recently installed MySQL and also created the basic user as scott but my doubt is regarding the roles. I don't understand different roles available for the user which I have created. I want ...
0
votes
1answer
414 views

Blocked access to batch file

I am unable to execute batch files to copy backups from SQL Server 2008 R2 hosted on Windows 2008 R2 to a file share. Error: Access denied SQL Server Agent service has full control on the ...
0
votes
1answer
451 views

Executing sys.dm_fts_parser without sysadmin server role

A web application needs to execute sys.dm_fts_parser to discover which words SQL Server Fulltext Search used to match documents for the purpose of syntax highlighting. That stored procedure can only ...
0
votes
1answer
33 views

Giving permission for each table within a database

I want to give different permission for different tables within a single database for a user.For example a user has full permission to a table while for another table only read permission.How it can ...
0
votes
1answer
2k views

Granting permissions only on a set list of objects

I have a SQL Server 2005 database with a large number of tables in the dbo schema. I now created a new schema (call it myschema) that only has three table-valued functions and two stored procedures in ...
0
votes
1answer
1k views

How to test permissions on an empty database?

It's usual in an organization I work in that I need to request a database creation to the DBA group (I am a developer). As such, they will also create a user for me to use and a database dedicated to ...
0
votes
1answer
23 views

Why can't I use a cname/alias in the permissions table?

At work we have a usual setup with web server(apache) and database server(mysql). From time to time there is the need to migrate the web stuff to a new server. Lets say their a records are dull and ...
0
votes
1answer
52 views

SSMS: Limit a login to be able to view and work only with some databases, but not able to make any changes on the server level

On a shared cloud we would like to work with one instance of MS SQL Server. Different clients have various databases. They can be owner of their databases and with DENY VIEW ANY DATABASE TO PUBLIC in ...
0
votes
1answer
25 views

Grant All privileges on all databases to a Mysql user

I try to give a user all the privileges on all the databases : mysql> GRANT ALL ON "." TO 'AppBD'@'192.168.1.5' IDENTIFIED BY 'admin'; ERROR 1064 (42000): You have an error in your SQL syntax; ...
0
votes
1answer
49 views

SQL Server Chain Permission

We have the 2 databases. Reporting HR There are some users who want to extract data from HR database. But we don't want to give direct access to that HR database. So, we created the special ...
0
votes
1answer
105 views

Procedure permission issues with a SQL state query

We have a login/user with DBO to a single database, and now we're adding a query that's providing some basic monitoring information requiring permissions extending somewhat to the sysadmin side. ...
0
votes
1answer
74 views

fn_trace_gettable Error SQL Server 2008

When I Execute SELECT * FROM FN_TRACE_GETTABLE(N'E:\Trace_Files\trace1.trc', 1) It says "You do not have permission to run 'FN_TRACE_GETTABLE", What type of permission on server required to execute ...
0
votes
1answer
20 views

Revoke delete from table for database owner

I am trying to revoke the DELETE privilege on a table for a database owner. I execute the command: REVOKE DELETE on my_table FROM database_owner; But when querying this via SELECT ...
0
votes
1answer
48 views

Possible to CREATE EVENT NOTIFICATION with a different owner?

We are in the process of removing a previous dba login and he owns all the endpoints and event notification objects. Endpoints were easy to change; Event notification objects not so much. I found ...
0
votes
1answer
81 views

PostgreSQL: After restoring data, unable to use Views (permission denied)

I'm attempting to get a PostgreSQL environment running locally. I'm using 9.2.8, and have restored data from a backup made by the DBA of the production environment. The restoration worked fine ...
0
votes
2answers
363 views

Hidden user rights

I'm running SQL Server 2008 R2 SP2. I have a SQL Server user, that the application uses to connect to my database. I've removed the user from all roles except public and the login from all database ...
0
votes
1answer
94 views

How to Revoke and Re-grant Permissions for an in-use MySQL User

We have a user which (wrongly) has global privileges (i.e. *.* rather then database specific). We would like to restrict this user to one database, so my approach would normally be to REVOKE ALL and ...
0
votes
1answer
1k views

PostgreSQL user permissions

I have a PostgreSQL 9.3 database with the PostGIS extension backing a web application and GeoServer. I have created three users. A read only user for accessing the data in the reference data schema. ...
0
votes
1answer
283 views

Is the [NT Service\SQLSERVERAGENT] a supported type for SQL Server Agent service?

Reading and re-reading MSDN "Select an Account for the SQL Server Agent Service". NT Service\SQLSERVERAGENT is not listed in the "Supported Service Account Types" section. And, if not, what is it ...
0
votes
1answer
5k views

How to copy backup files to remote share in SQL Server Agent job without AD/domain accounts involvement?

MS SQL Server 2012... with nightly databases backups to the same/local as SQL Server machine... I am trying to add another SQL Server Agent Job to copy the .bak files to remote (non-windows, i.e. ...
0
votes
3answers
1k views

how to grant select access my sql server

when I exec the syntax to gain the access I get an error that I cant grant permissions to my self. any Ideas please!
0
votes
2answers
2k views

how to join table from different database with different Users of database?

I have Two database called. Database1: host: 127.0.0.1 user: root1 pass: root1 dbname: db1 Table 1: Category ID INT(11) Primary Key Name VARCHAR(255) Database2: host: 127.0.0.2 ...
0
votes
1answer
396 views

How does security context propagate between schemas within a database?

We have a SQL Server 2008 database that contains two schema's. The owners of these schema's have been granted full SELECT permissions to all tables within each others ownership. I have created a ...
0
votes
1answer
1k views

Permissions on sys.syslogins

I've got the following scenario: ( loggend in on SQL-Server with full admin-privileges ) Creating LogIn, User, Role and associate them. IF NOT EXISTS( SELECT "name" FROM "master"."dbo"."syslogins" ...
0
votes
1answer
711 views

The UPDATE permission was denied on the object

I'm connecting to a remove Microsoft server running MsSQL via PHP. The code looks something like: $con = mssql_connect('0.0.0.0:123', 'user', 'pass') or die(log_mssql_error(__FILE__, __LINE__, ...
0
votes
1answer
1k views

MySQL '%' hostname wildcard

I've used the following to grant all privileges on mydb to myusername: GRANT ALL PRIVILEGES ON mydb.* to myusername @'%' IDENTIFIED BY 'mypassword'; I thought that the % is a wildcard for all ...
0
votes
2answers
85 views

Tiered permissions to generate conditional data access

I am working to improve the confidentiality and access level of the information presented within a program interface over top of a MySQL database. My goal is to create a two tier system: one based on ...
0
votes
1answer
431 views

Depicting permissions to access table via E -R diagram

I am designing a database schema for a web application. Its a first time I am designing a database with a commercial aim. I have started with drawing E-R diagrams after going through requirements ...
0
votes
0answers
22 views

Grant permissions on stored procedure

I created a user in SQL Server 2012 database and revoked all permissions given by the public role. Then i granted exec permission on a stored procedure. The user can execute the procedure but cannot ...
0
votes
0answers
32 views

Public Role Access For All Users in SQL Server

If I'm not mistaken this comes configured like this by default. Our new DBA stripped this permission and broke ownership chaining. In my mind "public" means "everyone" and hence the permission and ...
0
votes
0answers
12 views

Add user level permissions to MS Access by using a MySQL backend

I have a large Ms Access 2013 .accdb application which runs a lot of VBA code, with almost 60 users. I developed a user level permissions mechanism using vba but now plan to migrate the back-end to ...
0
votes
1answer
14 views

Maintaining permissions on a replicated view after reinitialization

When we were on SQL Server 2005, there was some way that I was able to keep custom permissions on a view at the subscriber. Now that I'm on SQL Server 2012, there doesn't seem to be a way to do ...
0
votes
0answers
19 views

what is the password to user mongodb when mongodb is installed in ubuntu?

When I installed mongodb in ubuntu, user mongodb and group mongodb are created in /etc/passwd and /etc/group. But I have no idea of the password to these user and group. I have to run mongod as root ...
0
votes
1answer
43 views

Server-wide Database Permissions in SQL Server

We have a SQL Server 2014 installation, which is accessible by a subset of our Active Directory users via Windows Authentication. Currently, when they log into the server for the first time they are ...
0
votes
0answers
17 views

Problem moving database to new server

I am currently running into two problems. First, when viewing tables using MySQL Query Browser, it keeps displaying "Could not fetch columns". Second, when attempting to go in an edit any of the ...
0
votes
0answers
128 views

MySQL workbench: Cannot Connect to Database Server (ssh)

General pointers would be appreciated -- it's likely I'm misunderstanding the mechanisms involved in a remote connection through ssh. I can use ssh to connect remotely, and then, through the CLI, ...