Notifications
Clear all
General Questions
2
Posts
2
Users
0
Reactions
993
Views
Apr 22, 2020 1:15 pm
hi
Issue when Suspended any account the sql server database not take offline . and user can access it normally
Sql Server 2016 in my case
just what I need
-- Take the Database Offline when Suspended
ALTER DATABASE [myDB] SET OFFLINE WITH
ROLLBACK IMMEDIATE
OR
-- Take the Database Online when make it Active
ALTER DATABASE [myDB] SET ONLINE
thank you
1 Reply
Apr 27, 2020 4:25 pm
Hello,
When you suspend the account the user is removed from the database roles to ensure they have no access.
Regards,
Trevor
