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 ?
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?
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.
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
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.
I don't have the exact info. But it looks like that is done through the SQL Server audit log. If you google "How to Enable SQL Server Audit and Review the Audit Log" there is an article on a site called netwrix that has a pretty good step by step
Never mind I found the problem I had to put Windows Authentication and SQL Management Server Authentication Right clicking the server->properties->server Authentication
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?
Usually that is done through the application, and not the database. In other words, if it is a web application, the web page will have logic in it that will check that, and keep the second person from logging in. If there is a way to do it directly with the database, I am not aware of it (though there may be a way)
@@keiljones2902 Thanks for your reply. I agree with you that permission will be done on the application itself. I tried to do it but I failed. If you could to show us with a short tutorial about the way to do it, i'll be very happy :).
Creating users and groups in SQL Server does not necessarily make the Db more secure. But at some point you are going to have to give in-house users, or programs which connect to the database, access to the database. This is just showing how to do that.
@@AeroTesting ask from your network adminstrator to create for you a domain local groups to make them log via windows authentication login and not sql server authentication login.
you are a beautiful human and have saved my life lol literally done everything I needed to do you legend
Perfect, helped me tremendously thank you!
Thanks i didnt know about the restriction of columns
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 ?
Beautifully explained. Thank you very much
Is there a way by which we can create new login using the "Windows Authentication option" by use of stored procedures.
Thanks for the video.
But how can I grant execute permission on only extended stored procedures
Thanks that was helpful.
Nice explanation thank you!
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?
Can we do this in for MS access migrated table
Fantastic explanation
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.
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
really very informative.
how to connect remotly to sql server ?
Great job , thank you very much
Thank you
Great - just what I needed. Thanks!
pro tip: you can watch movies at Flixzone. Been using it for watching loads of movies lately.
@Hendrix Sergio yea, been using flixzone for since november myself =)
can anyone help me on the exercise on chapter 12 (murach's SQL Server 2019 for developers)
Very helpful, Thank you very much.
HELPED ME LOTS...THANK YOU
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.
I don't have the exact info. But it looks like that is done through the SQL Server audit log. If you google "How to Enable SQL Server Audit and Review the Audit Log" there is an article on a site called netwrix that has a pretty good step by step
Great job, thanks so much
Can a read-only user run a Select query in SSMS?
yes
How can we revoke role access for a user from a group.
Thank you Keil!
Never mind I found the problem I had to put Windows Authentication and SQL Management Server Authentication Right clicking the server->properties->server Authentication
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?
Usually that is done through the application, and not the database. In other words, if it is a web application, the web page will have logic in it that will check that, and keep the second person from logging in. If there is a way to do it directly with the database, I am not aware of it (though there may be a way)
@@keiljones2902 Thanks for your reply. I agree with you that permission will be done on the application itself. I tried to do it but I failed. If you could to show us with a short tutorial about the way to do it, i'll be very happy :).
My sql server management asking for username.. where to get that user name?
Thank you so much
Thank you!
Great Job Thanx alot.
Useful
Tq so much sir
great .. Best expalnation but voice is to low
--0pasdffhiueuihfjdsfhpwoen this been typed by my cat lol
This is Good vdios but
But his voice was too low
with this system people can't hack DB and delete db?
Creating users and groups in SQL Server does not necessarily make the Db more secure. But at some point you are going to have to give in-house users, or programs which connect to the database, access to the database. This is just showing how to do that.
How i can fix that problem Sql for people no hack more and Delete DB have some solution for this?
@@AeroTesting ask from your network adminstrator to create for you a domain local groups to make them log via windows authentication login and not sql server authentication login.
your voice to low
Thank you!