I have a SQL Server and am looking at making it public.
What I mean by this is: I can create a DB and give access to myself and friends etc.
I need to create a login which can only view databases it has access, DISABLE access to stop the server.
I've played around with permissions and settings but every time it blocks the login.
Any advice would be appreciated.
SQL Server Express 2017 Windows Server Datacenter 2016
I would like have user which can have a database. These users can only access their database.
When I tried, I had access to stop the server. This is not idea for obvious reasons.
So, I need Databases, with logins , which can only access the database theyre assigned to and only read, write etc