Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.
0
votes
1answer
48 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
29 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
124 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
159 views
Why is a new user allowed to create a table?
I'm wondering why a newly created user is allowed to create a table after connecting to a database. I have one database, project2_core:
postgres=# \l
List of ...
0
votes
1answer
101 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
29 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
129 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
62 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
325 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
25 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 ...
0
votes
0answers
20 views
Trouble with ACE.OleDB.12.0 connection across domains
Here is the situation:
I have two servers, for simplicities sake we'll call them database-server and website-server.
The database-server is to hold an Access database that we're using during ...
0
votes
0answers
54 views
How to do point in time recovery of binary log files into .sql file
I have written a shell script to do an incremental backup of MySQL database.
For point in time recovery I'm using the binary logs generated in /var/lib/mysql directory.
For point-in-time recovery, Im ...
-4
votes
1answer
3k views
T-SQL to list all the user mappings with database roles/permissions for a User
I am looking for a t-sql script which can list the databases and and the respective roles/privileges mapped for a particular user. Using SQL Server 2008 R2.
Regards
Mohammed
