mysql - lock down view to be uneditable -

-

I am creating a database that includes public, private (limited to internal) and confidential data (to a lesser extent Limited). There are very specific requirements that the data security is managed by the database, but I am working in an environment where I do not have direct control of the permissions, and requesting change will take time (2-3 days) ).

That's why I created a structure to meet our structures without the need of many structures. I created two databases on the same server, which is an internal, table which is just something within some of our network's subnets The second public database can be edited by users, where using an administrator account, I want to highlight the public data in the internal database. Make limited thoughts to the public areas of the girls and it works well. However the data should flow on one side and the idea should not be able to write in the source table. And I can not lock public databases only for silting because public databases are used for various purposes of our public website.

So, to access some scripts, some field tables I need to make sure that these ideas can not be inserted, updated, or deleted in the source table. To create a view I use: 

  create algorithm = unused view 'table_view' from 'table'

Documentation to prevent updates Looking at this view, the total figure, the sub section that is in the WHERE section, should be ALGORITHM = TempTable. I would go with the template, but the manual is not clear that it will affect performance. In one paragraph it is said:

It is possible, if possible, merge onto the template, because the merge is usually more efficient

then immediately It says:

One of the reasons for choosing a template is clearly that after creating a temporary table the connection can be released to the built-in tables and used to terminate the statement. As a result, the MERGE algorithm goes Can accelerate lock release Lna to use other clients that view, they are not blocked for a long time.

Ideas are being asked to generate content to generate pages, whether the page can still be more efficient or less lock time Will give me better service? And no, due to the inability to permit permissions on individual areas to meet the requirements of legal privacy to handle it through account permissions, there really is no substitute for meeting each table with homogeneous privacy Need to split into 2-3 tables.

Should the algorithm be unfinished or templates, or another setting in the visual definition that will lock the view. And what would be the effect of the display? Besides, if I do something to force it to any work, like making Havings 1 to make an overall function force, to make it static and to choose the algorithm option.

I'm wondering why you do not just lock

MySQL roles Does not support, where I define a role without these grants & amp; With that role, the account (accounts) is connected ...


Comments

Post a Comment

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

-
I'm new to this I'm writing a clr. stored procedure that can be used to get values ​​used in a calculation Call for another stored procedure for Gives an archived methodology int (I think SqlInt32? Value of the table's value is int) which is then necessary to convert to decimal. Here I have the code: Public static integral mood (SQL MDMMYLUE, escalistering AMY type, out of SQLDCM Result) {aResult = 0; Try {SqlConnection conn = New SqlConnection ("Reference Connection = True"); SqlCommand cmd = New SqlCommand ("sp_GetType", conn); Cmd.Parameters.AddWithValue ("@ myValueType", aMyValueType); Cmd.CommandType = CommandType.StoredProcedure; Conn.Open (); Object type = CMD. Exclamation Asser (); Conn.Close (); Decimal type FORCalculation = Convert. ToDecimal (type); Decimal value = convert toDecimal (aMyValue); // ** calculation calc = new calculation (); Decimal result = calorie.docalulation (typefarculation, value); I get an exception...
Read more

Calling GetGUIThreadInfo from Outlook VBA -

-
I need to find the active window'm writing a VBA macro in MS Outlook, which is a specific process. The goal of this is to get the active window / document name even if its original application has more than one document interface. User processor with GetCurrentThreadId is active, I am using GetGUIThreadInfo to get .dll. Here is the correct code: private type RECT as as Left LongPtr top LongPtr right LongPtr down LongPtr termination of private type GUITHREADINFO cbSize as LongPtr flags LongPtr hwndActive LongPtr hwndFocus LongPtr hwndCapture LongPtr as as as as as reset as LongPtr rcCaret as LongPtr hwndCreate as LongPtr hwndMoveSize as HwndMenuOwner end of Private Equity PtrSafe function GetWindowThreadProcessId Lib "user32" (_BVV hnw LongPtr as LongPtr Nig Mr. announced as PtrSafe function GetGUIThreadInfo Lib "user32" _ (ByVal dwthreadid as LongPtr, _ lpguithreadinfo as GUITHREADINFO) LongPtr Sub MyFunction () as dim strWindowTitle string = space as s...
Read more

Obfuscating Python code? -

-
I'm looking for a way to hide my Python source code. print "Hello World!" How can I encode this example so that it is not human-readable? I have been asked to use Base 64 but I'm not sure how. itemprop = "text"> It is limited only, first level ambiguous resolution, but has built-in: byte-code in Python Is a compiler for: dragon-o-m py_compile & lt; Your program.py & gt; creates a .pyo file with a byte-code, and where the docstrings are removed, etc. You can rename .pyo with the .py extension, and python & lt; Your program.py & gt; runs as your program, but it does not have your source code. PS : If your program blur modules like this, you need to rename them with the .pyc suffix (I Not sure it will not break a day), or you can work with .pyo and run them with python -o ... .pyo ( Import should work). This will allow dragon to search your modules (otherwise, Python looks for the .py module).
Read more