How do I delete a user from the master database when the user has been deleted from the Server Logins using the SSMS Object Explorer

I am using an Azure SQL Database. I deleted some users from a Azure SQL database after I saw them mentioned in a Vulnerability Assessment report. Here’s how I deleted them:

  1. Log in to SSMS
  2. Expand the Object Explorer tree
  3. Expand the ‘Security’ folder
  4. Expand the ‘Logins’ folder
  5. Highlight the user
  6. Right-click and select ‘Delete’

I went back to the Vulnerability Assessment blade and ran a new ‘Scan’ but the users I deleted still show up in the list. The list included SQL code to show that my users still exist. I ran that code back in SSMS in the master database and confirmed my users still exist. Here’s the relevant code:

SELECT * FROM sys.database_principals

When I run the following code, I get an error saying the user does not exist (‘or you do not have permission’ – but I am a server admin so I ruled that out):

DROP LOGIN <username>

How do I get rid of these logins?

Does a buckler stack with the AC from the feat Shielded Gauntlet Master?

The biggest advantage of a buckler is that you keep a hand free while still gaining a shield bonus. You are also able to wear a gauntlet (normal, locked, or spiked) while keeping that hand free. Lets assume that the buckler is a +1 buckler so its providing a +2 shield bonus, and the gauntlet is just a +2.

The feat Shielded Gauntlet Master says

While using Shield Gauntlet Style, you no longer lose your shield bonus to AC when you attack with your gauntlet (or spiked gauntlet) or use it to hold a weapon. In addition, you add your gauntlet’s enhancement bonus to the shield bonus to AC granted by this feat as if it were a shield enhancement bonus.

So, does the bucklers shield bonus stack with the bonus from the feat? Since both would provide +2, is the final shield AC +2 or +4?

Does Voice of the Chain Master allow casting certain spells from an isolated space?

An interesting question popped into my brain recently while researching the Pact of the Chain for a Genie Patron Warlock. Casual shenanigans aside, I was wondering if taking Voice of the Chain Master allowed me to cast certain spells while safely tucked in my vessel but, maybe not in the way you think I’m going to ask about. Allow me to elaborate;

As per Voice Of The Chain Master

You can communicate telepathically with your familiar and perceive through your familiar’s senses as long as you are on the same plane of existence. Additionally, while perceiving through your familiar’s senses, you can also speak through your familiar in your own voice, even if your familiar is normally incapable of speech.

I’m led to believe that Bottled Respite is NOT another plane of existence, since similar items like a Portable Hole specifically mention when they are.

You can use an action to unfold a portable hole and place it on or against a solid surface, whereupon the portable hole creates an extradimensional hole 10 feet deep. The cylindrical space within the hole exists on a different plane, so it can’t be used to create open passages.

I think it’s safe to assume then, that the interior of the Vessel is simply ‘bigger on the inside’ and not an isolated dimension that you’re teleported to. With this in mind, let’s clarify one more subject before moving on.

I want to be clear; I’m not using my Familiar to ‘carry’ the spell. I understand those limitations. I’m using them purely for approximating my own visual range and my interest is in the wording of certain spells that require you to target ‘a creature you can see within range,’which also don’t otherwise state the spell ‘traveling’ through space in any specific fashion. Let’s set up our hypothetical from here, and pick a spell I personally think would have suitable water retention for this argument.

My Warlock is safely within a collar or ring (The Vessel) worn by my familiar (standing or sitting against nearest wall in the forward facing direction of the ring, to avoid losing as much spell range as possible), through which, I am perceiving through their sight as though I’m in their space (technically, I am, since they are carrying me.) I want to cast Flesh to Stone and I see a creature within 60ft of me (and am confident the range is correct because me and my familiar are occupying the same space). I cast Flesh to Stone which has a range of 60ft and, has the following description;

You attempt to turn one creature that you can see within range into stone. If the target’s body is made of flesh, the creature must make a Constitution saving throw. On a failed save, it is restrained as its flesh begins to harden. On a successful save, the creature isn’t affected.

A creature restrained by this spell must make another Constitution saving throw at the end of each of its turns. If it successfully saves against this spell three times, the spell ends. If it fails its saves three times, it is turned to stone and subjected to the petrified condition for the duration. The successes and failures don’t need to be consecutive; keep track of both until the target collects three of a kind.

If the creature is physically broken while petrified, it suffers from similar deformities if it reverts to its original state.

If you maintain your concentration on this spell for the entire possible duration, the creature is turned to stone until the effect is removed.

RAW it seems pretty sound from my point of view but, I also just really like this combat tactic so, I may be overlooking something. Thoughts?

Master of Many Forms Tripper Questions

So, general background is i am making a gestalt character and was dead set on basing it off of a tripper i absolutely loved playing awhile back. The DM is fairly open to any official source except BoED, BoVD, Dragon Mag, or any psionics. The last bit is what tripped (no pun intended) me up. The original build used psy warrior to get expansion for the ability to go large.

I came up with the idea of going master of many forms to get the Improved wild shape large and humanoid so i could just shape into a large version of myself.

My questions are…

  1. Would this work?
  2. How would stats be affected when i shape (i assume it would just be the standard medium to large adj, but i’m not sure)?
  3. Is there a better option out there (i know this plan comes with the issue with gear melding, i have plans for that as well)?

I have the build planned out to level 12 as of right now and would be more than willing to share if asked, but i don’t think those details are relevant to the questions right now.

Shield Master – Can the shield push be taken before an attack?

Can the shield push from the Shield Master feat be taken before an attack? i.e. Push prone, follow up with an attack while they’re down.

Shield Master

You use shields not just for protection but also for offense. You gain the following benefits while you are wielding a shield:

If you take the Attack action on your turn, you can use a bonus action to try to shove a creature within 5 feet of you with your shield.

What are the risks of upgrading DB major version in replica and then promoting it as master?

Recently AWS decided to force update all MariaDB RDS under 10.3, and I am using AWS and my RDS are using MariaDB 10.1. We are trying to minimize the downtime and any risk of data out of sync.

Our plan is to create a replica and upgrade it from 10.1 to 10.5. After that we will let it to consume binlog from old non-upgraded RDS then promoting it as Master and point our website to the newly created and upgrade RDS.

Assume we will have continuous stream of data coming into the RDS, what are the risk of steps above? Is the new RDS able to get all binlog genereated during the upgrade time? We estimated there will be ~ 1.5 hours to finish upgrading from 10.1 to 10.5

Thank you for helping

What is the “Ultimate Book of The Master”

Dragon magazine #82 features an article from Bruce Heard referencing magical research. One early chapter contains the following line:

To begin finding the answer to that question, we must first roll up our sleeves and open the Ultimate Book of The Master to page 115, whereupon begins the section on spell research

I have done a Google search, but cannot find any references to the "Ultimate Book of The Master". Does anyone have any information on what this book may be? Is it just a reference to a fictional in-game tome?

The specific edition referenced is AD&D (my understanding is that can mean 1st or 2nd edition and I am not sure which it refers to). The magazine was published in February 1984 if that helps.

If you use the Investment of the Chain Master Eldritch Invocation, does your familiar get a bonus to its saving throw DC from your own magic items?

The Investment of the Chain Master Eldritch Invocation states:

[…] When you cast find familiar, you infuse the summoned familiar with a measure of your eldritch power, granting the creature the following benefits: […]

[…] * If the familiar forces a creature to make a saving throw, it uses your spell save DC. […]

My question is, if the warlock has a Rod of the Pact Keeper, or Wand of the War Mage or something else which raises their saving throw DC, does the familiar inherit this when it triggers a saving throw? For example: If I had a DC 14 save with no gear and a DC 15 save with my +1 magic item, would the familiar use a 14 or a 15 for its save DC?