Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.
4
votes
1answer
2k views
SQL Server: hierarchy of permissions for schema?
We have several databases under development and I would like to start using SQL Server schemas for permission management and logical grouping of database objects. Under Schema Properties there is ...
2
votes
1answer
726 views
Possible to detach a database from SQL Server while retaining file permissions?
When a user detaches a database from MS SQL Server, it sets the owner of the data and log files to that user. It also removes all non-owner permissions from the files. This is partially explained at ...
1
vote
1answer
201 views
MySQL Grant Permission
I want to Grant a user only INSERT permission.
When I try to insert data, it throws the error "Access Denied".
What permission do I give a user to use/select database in mysql and how?
I have given ...
2
votes
2answers
809 views
Set permissions on a view
I'm creating a view on a SQL Server 2005 database via SQL Server Management Studio 2008, the view reads from two tables. The view is accessed from a web application and I want users to be able to ...
1
vote
1answer
746 views
SQL Server 2005 Easy way to add all users to a database role
I have three application databases: A, B and C. Users of A and B are all users in C; the users from A are in the public role with only SELECT permission, while the users from B are in a role with more ...
0
votes
1answer
330 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 ...
3
votes
1answer
627 views
How do you gain access to embedded MySQL database via localhost command line?
We run an application (Windows 2003 server) and would like to have database connectivity -- contacted the company and they do not have any documentation on how to do so. A quick glance at the ...
1
vote
3answers
4k views
When creating views, why do users need direct object permissions if they already have the same permissions via a role?
I'm having a problem with permissions in Oracle 10g. I'm hoping someone can help me make sense of this.
I have a schema with a table in it. I have granted select on that table to a role.
grant ...
3
votes
2answers
928 views
Role db_ddladmin not working properly on SQL Server 2008
I want to allow certain user to create/modify objects on a database(tables, views, sp's, functions, schemas etc) and don't want to give db_owner.
I thought I could do it with the db_ddladmin role, ...
4
votes
1answer
361 views
Is the PostgreSQL 'connection limit' shared across all users in a role?
I have created a role that many users can share:
> create role foo_read_only connection limit 5;
I have then assigned permissions to that role:
> grant select on table1 to foo_read_only;
...
2
votes
3answers
749 views
SQL Server Permission Denied Error When I'm DBOwner?
So I created an account, gave him dbcreator and securityadmin privileges and then through that account tried to run CREATE TABLE on a database that I had created and now owned, but was getting a ...
2
votes
1answer
1k views
How do I install pgcrypto on Windows?
I would like to install pgcrypto in Windows. I have a file C:\Program\PostgreSQL\9.0\share\contrib\pgcrypto.sql but when I try to run it in psql I get an error:
C:: Permission denied
How do I solve ...
3
votes
1answer
1k views
select permission was denied on the object 'sysjobs'
The select permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.
I have already tried to grant sqlagentoperatorrole and it didn't work. How do I resolve this error?
1
vote
2answers
427 views
Granting permission to SQL database
How do you grant a user xp_cmdshell, sp_OACreate, sp_OAmethod, and sp_Destroy on SQL server 2008? What is the prons and cons of granting this permission? Please let me know. Thank you!
1
vote
1answer
625 views
One MySQL user from 2 hosts not on same subnet
I've googled around for this with no luck. I have a master database with one slave. The perms for the slave are set and it runs fine. I'd like to add another slave using a clone of the original ...
4
votes
5answers
5k views
User Permissions Messed Up following a Backup -> Restore Operation
I had to move several SQL Server 2008 databases to our new db server so I backed them all up (to .bak files), copied these files over to the new box and restored them (all done using SQL Management ...
3
votes
1answer
113 views
Permissions Dropped after Package Failed
I created a local db and then set up a one-off job to copy the live db to this new db. Or at least that's what I thought I'd done. The logs suggest that the job thought it had to create the db on live ...
6
votes
6answers
436 views
Which database engines will allow me to GRANT/REVOKE on a specific column?
If I have a table with a single column of sensitive data, and I want to grant broad use of the table without exposing that one column, I know that I can create a VIEW that gives them access to all the ...
7
votes
2answers
13k views
Grant permissions to run an SQL server job
I have a job on my MSSQL server 2005, that I want to allow any database user to run.
I'm not worried about security, since the input to the job's actual work comes from a database table. Just running ...
6
votes
8answers
616 views
Granting SA privileges for Developers on the development box
In spite of our vehement protests, our management has decided that the development team must be granted 'sa' rights on the development server. The catch is that we, the DB support group are still ...
