Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]
Tag: role
With LocalAdmin become sysadmin SQL Server
Question : I am a local Admin on my machine. My account wasn’t added when SQL Server was installed, and […]
Setting up a simple “permissions architecture” in PostgreSQL
Question : I host the databases of several clients. For each database dbname, I currently have a dbnameusers role that […]
Create Role or Create user
Question : PostgreSQL version : 11.2 OS platform : RHEL 7.6 I am new to PostgreSQL. I have a CRM […]
Is there a backup operator role in Microsoft SQL Server 2008?
Question : I have a Windows Server 2008 with Microsoft SQL Server 2008 and VERITAS NetBackup installed. Basically, this NetBackup […]
Why availability group resource goes offline in WSFC?
Question : Sometimes I find the AG Cluster role in offline state which results the AG in resolving state. It […]
Group permissions in postgreSQL not inheriting to table level
Question : I am moving to a group role from a lot of individual users and have one table that […]
How can I create postgres users for employees that have limited access?
Question : I want to create postgres users for our staging + production databases that allow the users limited access […]
how to use is_srvrolemember to list all server roles of a user
Question : For dealing with server permissions I am currently using a procedure called sp_SrvPermissions V6.0 by Kenneth Fisher thank […]
How do I add multiple users to a role in one statement?
Question : I simply want to add multiple users that I have created to a created role then grant all […]