如何删除SAP在用户修改表结构时创建的临时表_百度知道
如何删除SAP在用户修改表结构时创建的临时表
提问者采纳
Rename Table and Create Secondary Indexes Table QCM8TAB is renamed to TAB, contain any data, however. The following example shows the steps necessary for a conversion Initial Situation点此发表你的看法&gt. Thus the ABAP Dictionary contains only one active version of table TAB. SAP关于修改表结构时发生的操作说明如下, table QCMTAB is kept for safety reasons! Programs that access tables might otherwise not execute correctly, requiring additional space. The table TAB is created in the database with its new structure under the name QCM8TAB. If duplicate records appeared in table QCM8TAB, you should clean up the data of the table before conversion. In general it is not possible to determine in advance which record this will be. The table is converted in a series of 7 steps. The ABAP Dictionary therefore contains an active version (where the field has a length of 60 places) and a revised version (where the field only has a length of 30 places) of the table, this table is deleted befor&gt, in which field 3 has a length of 30, that is Field 3 currently has 60 places in the database. The active version of the table is created in the database. After this step, the data is present in both tables. If the conversion terminates, provided that all records could be copied from table QCMTAB into table QCM8TAB. Step 2: Activating Tables The revised version of the table is activated in the ABAP Dictionary： Conversion Process Table TAB was changed in the ABAP Dictionary. At this time the length of a field (Field 3) was reduced from 60 to 30 places. Step 4. The conversion process therefore needs 16 MB of resources in the rollback segment. When the length of a field is reduced, 必须从系统中删除这些QCM表. Step 5, you can find the place where the conversion terminated in the reset log (last step to be executed). You must find out why the conversion terminated (for example overflow of the corresponding tablespace)export&quot. For this reason conversions may not be running during production, only one of these records can be reloaded: Remove the Lock The lock set at the beginning of the conversion is removed. You must then continue the terminated conversion (see Conversion Problems).Continuing Terminated Conversions)，系统会将临时表的数据拷贝回数据表. For this reason. Step 6. If the conversion terminates (see You must clean up terminated conversions: Delete the QCM Table The data in table QCMTAB is no longer required at the end of the conversion. If in the database a table named QCMTAB already exists (for example. At least all the applications that use the table to be converted must be deactivated. Each successful step of the conversion is recorded in this reset log. Step 1. Step 7, because the key of table TAB was shortened: Rename Table The table is renamed in the database. In addition. When the length of a key is reduced and there are several records whose new key cannot be distinguished, for example. All the views that use the table are deleted from the database, the table stays locked is a reset log is written. The name of the new table consists of the prefix QCM and the table name. In such a case: Set Lock The table is locked against further structural changes。 注意. Reducing the length of a field results in a table conversion. Otherwise a program could behave incorrectly when reading the table since some of the records were not yet copied back from the temporary table. Two secondary indexes that were also created in the database are defined in the ABAP Dictionary for the table. The table already contains data, programs must not access the table while the conversion is running：当你要进行系统拷贝时: Reload Data The data is copied from table QCMTAB to table QCM8TAB (with the ABAP command MOVE-CORRESPONDING), the primary index of the table is created in the database. The secondary indexes on the table defined in the ABAP Dictionary are newly created in the database. The structure of database table QCM8TAB thus corresponds to the structure of table TAB in the ABAP Dictionary after this step. You can find information about how existing entries are handled in a field when the field type changes in the ABAP documentation about the MOVE-CORRESPONDING statement. The table data is only consistent again once Step 4 has been completed. Before converting large tables. The views on the table that were deleted in the first step are also newly created in the database. Step 3，你必须在&quot. The table is therefore deleted. The name of the temporary table for table TAB is thus QCMTAB;, the extra places are truncated when the field is reloaded. The restart log is deleted together with the lock when the conversion has been completed. When you copy data from table QCMTAB into table QCM8TAB, you should therefore check whether the relevant tablespace has enough space left，否则导入会出错, a database commit is stored after 16 MB, from a previous conversion attempt). All indexes on the table are deleted. This lock mechanism prevents a new structural change from being made before the conversion has finished correctly，当新表结构完成后这个临时表用于先将需要改变结构的表数据保存下来. The database table does not
其他类似问题
为您推荐：
临时表的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁如何将用户修改表结构的权限去掉_百度知道
如何将用户修改表结构的权限去掉
我有更好的答案
什么数据库？
其他类似问题
为您推荐：
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁上一篇：下一篇：
相关文章列表查看: 10839|回复: 8
如何让表格结构不被修改，表内文字可以编辑？
阅读权限30
在线时间 小时
如何让表格结构不被修改，表内文字可以编辑？
11:58 上传
点击文件名下载附件
11.08 KB, 下载次数: 47
阅读权限10
在线时间 小时
先复制你所要的表格结构，再选择性粘贴中的格式
阅读权限30
在线时间 小时
选择性粘贴
阅读权限30
在线时间 小时
www9009 发表于
选择性粘贴
做过，但还是不会做
阅读权限30
在线时间 小时
muzhou 发表于
做过，但还是不会做
如果excel做的话可以用保护单元格就行，word就没有使用过。
阅读权限70
在线时间 小时
参见此地址的第一个问题，我已实践成功！其实以前也实践过，但忘了怎么做，今天又实践成功了！楼主也实践一下吧！/zh-cn/word-help/HA.aspx如果是 WORD 2003，可在“工具菜单”点“保护文档”。
阅读权限70
在线时间 小时
为文档添加保护并标记可以修改的部分
在“审阅”选项卡上的“保护”组中，单击“限制编辑”。
在“编辑限制”区，选择“仅允许在文档中进行此类型的编辑”复选框。
在编辑限制列表中，单击“不允许任何更改(只读)”。
选中允许修改的文档部分。
例如，选中多个段落、标题、句子或单词。
提示& &若要同时选中文档中的多个部分，请先选择一部分，然后按住 Ctrl 键并选中其他部分。
在“例外项”下，执行下列操作之一：
要允许打开文档的任何人都能编辑所选部分，请选择“组”列表中的“每个人”复选框。
若要仅允许特定人员编辑您选中的部分，请单击“其他用户”，然后键入用户姓名。
若要允许您自己也能编辑该文档部分，请包括您的姓名。各姓名之间以分号分隔。
要点& &若想以用户验证而非密码保护的方式来保护文档，请确保键入各用户姓名的电子邮件地址，而非 Microsoft Windows 或 Windows Vista 用户帐户。
单击“确定”，然后选择允许编辑所选部分的用户姓名旁的复选框。
注释& &若要选择多人，请将这些人员作为项添加到“组”框中，以便您能再次快速选择他们。
继续选择文档部分，并分配可对其进行编辑的用户权限。
在“启动强制保护”下，单击“是，启动强制保护”。
请执行下列操作之一：
若要给文档指定密码，以便知道密码的用户能解除保护，请在“新密码(可选)”框中键入密码，然后确认该密码。
注释& &如果您计划以共同创作的方式发布文档，那么您必须使用此选项。
使用由大写字母、小写字母、数字和符号组合而成的强密码。弱密码不混合使用这些元素。例如，Y6dh!et5 是强密码；House27 是弱密码。密码长度应大于或等于 8 个字符。最好使用包括 14 个或更多个字符的密码。有关详细信息，请参阅使用强密码有助于保护个人信息。
记住密码很重要。如果忘记了密码，Microsoft 将无法找回。最好将密码记录下来，保存在一个安全的地方，这个地方应该尽量远离密码所要保护的信息。
阅读权限70
在线时间 小时
Word 2003 中保护文档——具体操作：
1、如果没有把握，可以把要处理的文档复制一份放在它处。
2、打开要保护的文档，点击”工具“菜单——保护文档——
3、右侧勾选“仅允许在文档中进行此类编辑”复选框
——下面是“未作任何更改（只读）”这个不要动
4、然后用鼠标选定一段或一行文字，或一个表格单元格，然后按住 CTRL 键不松手，继续点击文档页面上你认为可以让用户编辑的部分（如果是文字，可以在左侧空白处点击或拖动鼠标也可；如果是表格，将光标放在单元格左框线边上可选中该单元格），CTRL键始终按住不动，直到你认为可以让用户编辑的部分都选择完毕，再松手——
5、再在下面的“例外项（可选）中，勾选”每个人“复选框，
6、再点击”是，启动强制保护“——可键入密码，也可以不键入密码直接确定
7、保存退出，再调入试验一下是否达到目的。
阅读权限30
在线时间 小时
跟着做，成功了。
玩命加载中，请稍候
玩命加载中，请稍候
Powered by
本论坛言论纯属发表者个人意见，任何违反国家相关法律的言论，本站将协助国家相关部门追究发言者责任！ & & 本站特聘法律顾问：徐怀玉律师 李志群律师查看:3753|回复：3
请问：怎样能够做到让用户只能对表的数据进行增删改查，而不能进行修改表结构？
我想建一个这样的用户出来，直接grant select to user，这样会报错。
之前看到别人用同义词的方式实现了，具体怎么做就不知道。
请教各位大侠。:(
正确的语法是，grant select on OBJECT_NAME to USER_NAME
select是对象权限，所以要加个OBJECT_NAME，而像诸如grant connect to user 的系统权限的授予才不加on OBJECT_NAME
grant alter any table to &用户名&;
grant select any table to &用户名&;
这个是改表和查表，key和index都不行