Quick Tutorial - Users and Permissions in SQL Server

[darrylw]

Thanks i didnt know about the restriction of columns

[ClassiqLNative]

you are a beautiful human and have saved my life lol literally done everything I needed to do you legend

[JohnSmith-nomk]

Perfect, helped me tremendously thank you!

[manushafernando]

Beautifully explained. Thank you very much

[EminoMeneko]

Cool. Just for the later example. What would be the result of SELECT * for bobby? Would it complain about not being given permission on the 3rd column ?

[elacomedido]

Never mind I found the problem I had to put Windows Authentication and SQL Management Server Authentication Right clicking the server->properties->server Authentication

[vijayparise]

Thanks for the video.

But how can I grant execute permission on only extended stored procedures

[Winterstick]

So I create the user acct and give it owner permission(this is what I need to do), then I provide the other person on another computer my SQL server name along with the user id and password and they should be able to see the database as I do on my laptop?

[malthesrensen]

So you are denying the rights to lots of things by clicking deny on every single item. I imagine it would also be possible to deny everything by default on databaselevel and then grant rights to few specific things on tables, views, procedures etc. Could anyone elaborate on this, cause when when i deny a user from Selecting and Inserting in the database properties, he is still able to select from or insert into any table

[scientist]

When installing SQL server in a non server environment like Windows 10, how can a user access the server table? Just install the mgmt studio and provide the domain name within the network? Thanks in advance.

[PritamSingh]

Can we do this in for MS access migrated table

[McCallumClips]

Great video. Informative and to the point. Very useful. Thanks. Do you know of a way to track a SQL account and what it has been doing? The SQL account I have is for automated jobs but I think someone may also be using it to access a SQL Server they should not be on.

[abdallahbelcaid]

how to connect remotly to sql server ?

[simeonobafemi]

can anyone help me on the exercise on chapter 12 (murach's SQL Server 2019 for developers)

[injamharitha]

How can we revoke role access for a user from a group.

[besamahmed]

How can i permit only one user to log in into my application at the same time and update database, Access local database?, because when more than one user logs in at the same time only the first will have his data stored in Access database file and not the others. Do you have a solution for this issue pls?

[htgdev]

My sql server management asking for username.. where to get that user name?

[mariejulie]

Can a read-only user run a Select query in SSMS?

[miteshjain]

great .. Best expalnation but voice is to low

[Rainfall]

This is Good vdios but
But his voice was too low