Quick Tutorial - Users and Permissions in SQL Server

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น • 50

  • @ClassiqLNative
    @ClassiqLNative 2 ปีที่แล้ว +1

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

  • @JohnSmith-no7mk
    @JohnSmith-no7mk ปีที่แล้ว +1

    Perfect, helped me tremendously thank you!

  • @darrylw99
    @darrylw99 3 หลายเดือนก่อน +2

    Thanks i didnt know about the restriction of columns

  • @EminoMeneko
    @EminoMeneko 4 ปีที่แล้ว +1

    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 ?

  • @manushafernando9938
    @manushafernando9938 3 ปีที่แล้ว +1

    Beautifully explained. Thank you very much

  • @AymaanKhan-h1t
    @AymaanKhan-h1t 3 หลายเดือนก่อน

    Is there a way by which we can create new login using the "Windows Authentication option" by use of stored procedures.

  • @vijayparise8502
    @vijayparise8502 3 ปีที่แล้ว

    Thanks for the video.
    But how can I grant execute permission on only extended stored procedures

  • @CaribouDataScience
    @CaribouDataScience 11 หลายเดือนก่อน

    Thanks that was helpful.

  • @arturopresa6552
    @arturopresa6552 2 ปีที่แล้ว

    Nice explanation thank you!

  • @Winterstick83
    @Winterstick83 ปีที่แล้ว

    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?

  • @PritamSingh9119
    @PritamSingh9119 10 หลายเดือนก่อน

    Can we do this in for MS access migrated table

  • @carlospadetto
    @carlospadetto 5 ปีที่แล้ว

    Fantastic explanation

  • @scientist100
    @scientist100 4 ปีที่แล้ว

    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.

  • @malthesrensen4953
    @malthesrensen4953 4 ปีที่แล้ว +1

    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

  • @zahidimranx
    @zahidimranx 2 ปีที่แล้ว

    really very informative.

  • @abdallahbelcaid3002
    @abdallahbelcaid3002 4 ปีที่แล้ว +1

    how to connect remotly to sql server ?

  • @MrQUQUQUQU1
    @MrQUQUQUQU1 7 ปีที่แล้ว +1

    Great job , thank you very much

  • @bogdanudovicic391
    @bogdanudovicic391 5 ปีที่แล้ว

    Great - just what I needed. Thanks!

    • @hendrixsergio5474
      @hendrixsergio5474 3 ปีที่แล้ว

      pro tip: you can watch movies at Flixzone. Been using it for watching loads of movies lately.

    • @jasearturo9181
      @jasearturo9181 3 ปีที่แล้ว

      @Hendrix Sergio yea, been using flixzone for since november myself =)

  • @simeonobafemi5596
    @simeonobafemi5596 3 ปีที่แล้ว

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

  • @subhenshujena9862
    @subhenshujena9862 5 ปีที่แล้ว

    Very helpful, Thank you very much.

  • @carlospadetto
    @carlospadetto 5 ปีที่แล้ว

    HELPED ME LOTS...THANK YOU

  • @McCallumClips
    @McCallumClips 3 ปีที่แล้ว

    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.

    • @keiljones2902
      @keiljones2902  3 ปีที่แล้ว +1

      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

  • @abdul-rashidmohammed9528
    @abdul-rashidmohammed9528 4 ปีที่แล้ว

    Great job, thanks so much

  • @mariejulie98
    @mariejulie98 4 ปีที่แล้ว

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

  • @injamharitha4858
    @injamharitha4858 4 ปีที่แล้ว

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

  • @ronaldcrespo6138
    @ronaldcrespo6138 3 ปีที่แล้ว

    Thank you Keil!

  • @elacomedido
    @elacomedido 2 ปีที่แล้ว

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

  • @besamahmed692
    @besamahmed692 3 ปีที่แล้ว

    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?

    • @keiljones2902
      @keiljones2902  3 ปีที่แล้ว

      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)

    • @besamahmed692
      @besamahmed692 3 ปีที่แล้ว

      @@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 :).

  • @htgdev3700
    @htgdev3700 4 ปีที่แล้ว

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

  • @vikashpandey6495
    @vikashpandey6495 ปีที่แล้ว

    Thank you so much

  • @rebcod
    @rebcod 3 ปีที่แล้ว

    Thank you!

  • @loayoraby674
    @loayoraby674 5 ปีที่แล้ว

    Great Job Thanx alot.

  • @Cahangir
    @Cahangir หลายเดือนก่อน

    Useful

  • @rockonrock7333
    @rockonrock7333 ปีที่แล้ว

    Tq so much sir

  • @miteshjain4549
    @miteshjain4549 4 ปีที่แล้ว

    great .. Best expalnation but voice is to low

    • @mohammedsahnon6356
      @mohammedsahnon6356 4 ปีที่แล้ว

      --0pasdffhiueuihfjdsfhpwoen this been typed by my cat lol

  • @Rainfall2040
    @Rainfall2040 4 ปีที่แล้ว

    This is Good vdios but
    But his voice was too low

  • @AeroTesting
    @AeroTesting 7 ปีที่แล้ว

    with this system people can't hack DB and delete db?

    • @keiljones2902
      @keiljones2902  7 ปีที่แล้ว

      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
      @AeroTesting 7 ปีที่แล้ว +1

      How i can fix that problem Sql for people no hack more and Delete DB have some solution for this?

    • @loayoraby674
      @loayoraby674 5 ปีที่แล้ว

      @@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.

  • @vipinmavi5591
    @vipinmavi5591 4 ปีที่แล้ว +5

    your voice to low

  • @hawariaw8953
    @hawariaw8953 2 ปีที่แล้ว

    Thank you!