Question : I have an SSIS package that I would like to run as a job. The flat file source […]
Category: Permissions
Permission denied when trying to install sp_blitz on in the master database in Amazon RDS
Question : I am trying to install sp_blitz on AWS RDS SQL Server (14.0.3223.3) standard edition and getting following error: […]
pg_dump: Show GRANT Statements only
Question : I executed this manually: GRANT SELECT ON TABLE my_table TO some_user; How can I dump this statement again? […]
GRANT EXECUTE ON SomeProc TO SomeRole AS dbo
Question : I have a role ExecSP which I use to manage who can execute stored procedures. EXECUTE permission is […]
Hide Table Structure
Question : Is there a way to restrict a user from viewing the table structure? I just want them to […]
SQL Server on Linux, an issue with filesystem privileges for a backup creation
Question : I’m trying to backup SQL Server to a directory that different users should have access to. To do […]
PostgreSQL user only drop some tables
Question : Is there a way to have a PostgreSQL user that can drop all but specified tables? We need […]
Grant a database role in current database with permission to execute a SP in msdb
Question : I have created a role in my current SQL Server 2012 database with db_datareader, db_datawriter, and execute permissions. […]
db2_install do not have write permission on the directory or file
Question : This is the error I encountered (I ran the db2_install and everything else as root,): DBI1288E The execution […]
Oracle: are objects created by sys in a schema the same as objects created by that user?
Question : For example, are there any differences between: SCOTT@ORCL> create index a_idx on a(x); and SYS@ORCL> create index scott.a.idx […]