Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Category: Permissions

How can I create a role to create,update,delete stored procedures and views

By adminPosted on January 28, 2023

Question : what permissions do I need to give in order to achieve the above task to get users the […]

Database user permissions: GRANT VIEW DEFINITION but DENY on some object types

By adminPosted on January 28, 2023

Question : I’m trying to figure out a combination of permissions that will allow a partner to see basic db […]

Do not have permission to use ‘dbo’ when creating a view

By adminPosted on January 27, 2023

Question : I want to create a user with minimal required access to two databases within a server. The user […]

What is the minimum privilege required to create a full text index?

By adminPosted on January 27, 2023

Question : I just created a full text catalog on my database. I now have a developer who needs the […]

What privileges are needed to run EXPLAIN PLAN FOR CREATE INDEX?

By adminPosted on January 26, 2023

Question : My user can EXPLAIN PLAN FOR any query I like, but not for CREATE INDEX. I need to […]

Limit access to specific database only, and restrict access to system tables

By adminPosted on January 26, 2023

Question : I have a user test, which can view data from the system tables such as pg_class. The idea […]

Create Temporary Access to production support

By adminPosted on January 25, 2023

Question : We’re thinking of creating a web site where a manager can provide temporary access to a person for […]

How can I limit a user to only be able to run procs in a schema, which access another db?

By adminPosted on January 23, 2023

Question : In a SQL Server 2012 SP2 Standard Edition instance I have a user in database A that needs […]

Access to the path ‘c:somepath’ is denied for MSSQL CLR

By adminPosted on January 23, 2023

Question : I think this is a permissions problem, but I’m having trouble locating it. I have a group of […]

Audit Plugin on Ubuntu: CONTROL [main] Failed global initialization: FileNotOpen: Failed to open “/path” : exit status 1

By adminPosted on January 23, 2023

Question : We use MongoDB 3.2.11 and try to enable Audit. New in version 2.6. MongoDB Enterprise includes an auditing […]

  • 1
  • 2
  • 3
  • …
  • 111

Recent Posts

  • Inner procedure is rolled back but outer procedure is still committed
  • Is there a better way to add failed node back to postgres cluster?
  • How can I create a role to create,update,delete stored procedures and views
  • Is ASYNC_NETWORK_IO wait type anything to worry about?
  • Logical optimization of joins and selections
  • Is it possible to install Developer Edition of SQL Server as the primary development server?
  • Is “deadlock detected” really an error? Should I be suppressing them after handling them?
  • Backup not creating a new file
  • Locking issue with concurrent DELETE / INSERT in PostgreSQL
  • Does InnoDB store row counts in secondary index B-Tree non-leaf nodes?
  • Insert multiples rows/columns – PostgreSQL 9.2
  • Test if any columns are NULL
  • Profiling a PostgreSQL function [duplicate]
  • Why is MySQL database data-files deployed under /var/lib/mysql?
  • postgres finding child tables for particular table
  • InnoDB row metadata size (minimum row size)
  • Restoring SQL Server Database Command Line Error
  • Wrong sharding on mongoDB 3.0
  • how can I join two very different table structures? No common keys
  • How to get next value of Sequence dynamically in Oracle

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding