Permission on Database












1















I have a login user called TestUser created at the server level that is assigned to a read only role, now I need to create a user for the TestUser login on MyDb



USE [MyDB]
GO
CREATE USER [Test] FOR LOGIN [TestUser]
GO
GRANT SELECT TO [Test]
GO
DENY DELETE TO [Test]
GO
DENY INSERT TO [Test]
GO
DENY UPDATE TO [Test]
GO


everything is good but when I script that Test user created, I don't see in any place the script that I'm giving select and denying insert, delete and update










share|improve this question









New contributor




user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    1















    I have a login user called TestUser created at the server level that is assigned to a read only role, now I need to create a user for the TestUser login on MyDb



    USE [MyDB]
    GO
    CREATE USER [Test] FOR LOGIN [TestUser]
    GO
    GRANT SELECT TO [Test]
    GO
    DENY DELETE TO [Test]
    GO
    DENY INSERT TO [Test]
    GO
    DENY UPDATE TO [Test]
    GO


    everything is good but when I script that Test user created, I don't see in any place the script that I'm giving select and denying insert, delete and update










    share|improve this question









    New contributor




    user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      1












      1








      1








      I have a login user called TestUser created at the server level that is assigned to a read only role, now I need to create a user for the TestUser login on MyDb



      USE [MyDB]
      GO
      CREATE USER [Test] FOR LOGIN [TestUser]
      GO
      GRANT SELECT TO [Test]
      GO
      DENY DELETE TO [Test]
      GO
      DENY INSERT TO [Test]
      GO
      DENY UPDATE TO [Test]
      GO


      everything is good but when I script that Test user created, I don't see in any place the script that I'm giving select and denying insert, delete and update










      share|improve this question









      New contributor




      user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I have a login user called TestUser created at the server level that is assigned to a read only role, now I need to create a user for the TestUser login on MyDb



      USE [MyDB]
      GO
      CREATE USER [Test] FOR LOGIN [TestUser]
      GO
      GRANT SELECT TO [Test]
      GO
      DENY DELETE TO [Test]
      GO
      DENY INSERT TO [Test]
      GO
      DENY UPDATE TO [Test]
      GO


      everything is good but when I script that Test user created, I don't see in any place the script that I'm giving select and denying insert, delete and update







      sql-server permissions users






      share|improve this question









      New contributor




      user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question









      New contributor




      user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question








      edited 1 hour ago









      LowlyDBA

      7,24752643




      7,24752643






      New contributor




      user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 2 hours ago









      user175111user175111

      132




      132




      New contributor




      user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      user175111 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          1 Answer
          1






          active

          oldest

          votes


















          4














          Most probably because you are using the generate scripts method to do so.



          I would suggest to use open source DBA tools to view the permission or export.



          Aliases : Export-SqlUser



          Synopsis



          Exports users creation and its permissions to a T-SQL file or host.



          Description



          Exports users creation and its permissions to a T-SQL file or host. Export includes user, create and add to role(s), database level permissions, object level permissions.






          share|improve this answer


























          • is it probably Export-DbaUser?

            – user175111
            43 mins ago











          • One more question, can we install this in a prod server?

            – user175111
            38 mins ago











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "182"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          user175111 is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f232788%2fpermission-on-database%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          4














          Most probably because you are using the generate scripts method to do so.



          I would suggest to use open source DBA tools to view the permission or export.



          Aliases : Export-SqlUser



          Synopsis



          Exports users creation and its permissions to a T-SQL file or host.



          Description



          Exports users creation and its permissions to a T-SQL file or host. Export includes user, create and add to role(s), database level permissions, object level permissions.






          share|improve this answer


























          • is it probably Export-DbaUser?

            – user175111
            43 mins ago











          • One more question, can we install this in a prod server?

            – user175111
            38 mins ago
















          4














          Most probably because you are using the generate scripts method to do so.



          I would suggest to use open source DBA tools to view the permission or export.



          Aliases : Export-SqlUser



          Synopsis



          Exports users creation and its permissions to a T-SQL file or host.



          Description



          Exports users creation and its permissions to a T-SQL file or host. Export includes user, create and add to role(s), database level permissions, object level permissions.






          share|improve this answer


























          • is it probably Export-DbaUser?

            – user175111
            43 mins ago











          • One more question, can we install this in a prod server?

            – user175111
            38 mins ago














          4












          4








          4







          Most probably because you are using the generate scripts method to do so.



          I would suggest to use open source DBA tools to view the permission or export.



          Aliases : Export-SqlUser



          Synopsis



          Exports users creation and its permissions to a T-SQL file or host.



          Description



          Exports users creation and its permissions to a T-SQL file or host. Export includes user, create and add to role(s), database level permissions, object level permissions.






          share|improve this answer















          Most probably because you are using the generate scripts method to do so.



          I would suggest to use open source DBA tools to view the permission or export.



          Aliases : Export-SqlUser



          Synopsis



          Exports users creation and its permissions to a T-SQL file or host.



          Description



          Exports users creation and its permissions to a T-SQL file or host. Export includes user, create and add to role(s), database level permissions, object level permissions.







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited 1 hour ago









          LowlyDBA

          7,24752643




          7,24752643










          answered 2 hours ago









          KASQLDBAKASQLDBA

          5,54261944




          5,54261944













          • is it probably Export-DbaUser?

            – user175111
            43 mins ago











          • One more question, can we install this in a prod server?

            – user175111
            38 mins ago



















          • is it probably Export-DbaUser?

            – user175111
            43 mins ago











          • One more question, can we install this in a prod server?

            – user175111
            38 mins ago

















          is it probably Export-DbaUser?

          – user175111
          43 mins ago





          is it probably Export-DbaUser?

          – user175111
          43 mins ago













          One more question, can we install this in a prod server?

          – user175111
          38 mins ago





          One more question, can we install this in a prod server?

          – user175111
          38 mins ago










          user175111 is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          user175111 is a new contributor. Be nice, and check out our Code of Conduct.













          user175111 is a new contributor. Be nice, and check out our Code of Conduct.












          user175111 is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f232788%2fpermission-on-database%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          How to label and detect the document text images

          Vallis Paradisi

          Tabula Rosettana