Recently, because of work requirements, has built a landing in the database, limiting some permissions, but through the login to connect to the database in the pb, found that although table modify, delete, insert, such as permissions is some, but not in the table of open directly modified operation, very uncomfortable, may I ask who you are is clearly, database management aspects of the problem was, pb set issues, please comment, thank you very much!

CodePudding user response:

Your table is not set primary key

CodePudding user response:

See not quite understand!

If the PB to the user to connect to the database, basic modify, delete, insert, and other functions are effective, that means the user has permissions! Vice is not!

CodePudding user response:

Thank you for your reply, to be sure that after using the new login to connect to the database cannot be opened directly modify data in the table, but with the update and delete statements can be modified, such as suggesting that permissions are indeed some, is not directly modify,

CodePudding user response:

Pb should be set in again.

CodePudding user response:

Oh, so ah, you mean in creating data objects that cannot be modified?
If so, then you update attribute set?

CodePudding user response:

It must be table don't have a primary key,

CodePudding user response:

Men, I repeated again, my question is, when open the table with a select statement in the original concept, can't modify the data directly in the open table screen, does not involve the issue of pb in the data window, table's primary key is some, with sa in pb connection is no problem, but after the new login connection have a problem, a new land change, insert, update the permissions have been set up, and also can be modified with the command, just can not directly modify, hope this can clarify the problem, appreciate your guidance,

CodePudding user response:

I don't understand, it is estimated that no one help got you
Help you top

CodePudding user response:

Please try in front of the table name plus DBO

CodePudding user response:

Thank you very much! ZJS818 approach worked, thank you!

There is a problem is to amend the "view", plus the dbo. Effective for table, but the view or not, hope to be able to continue to support,