Problem Note 37492: Create permission does not appear in the Authorization tab for table objects
If you open the Properties window for a table object in SAS® Management Console and navigate to the Authorization tab, you will see a list of permissions for the table that you can then grant or deny. The Create permission is omitted from the list of permissions.
However, the Create permission is required to be granted in order to add or delete records from a table when that table's library is assigned with the META engine. Since the Create permission can not be modified at the table level, the only circumvention is to grant the Create permission on the Folder of which that table is a member. Note that this effectively grants Create permission on all objects within that Folder.
Operating System and Release Information
| SAS System | SAS Management Console | Solaris for x64 | 9.2 TS2M0 | 9.2 TS2M3 |
| Linux for x64 | 9.2 TS2M0 | 9.2 TS2M3 |
| Linux | 9.2 TS2M0 | 9.2 TS2M3 |
| 64-bit Enabled Solaris | 9.2 TS2M0 | 9.2 TS2M3 |
| 64-bit Enabled HP-UX | 9.2 TS2M0 | 9.2 TS2M3 |
| 64-bit Enabled AIX | 9.2 TS2M0 | 9.2 TS2M3 |
| Windows Vista | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.2 TS2M3 |
| HP-UX IPF | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | 9.2 TS2M3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The Create permission does not display in the Authorization tab of a table's properties in SAS® Management Console.
| Type: | Problem Note |
| Priority: | high |
| Topic: | System Administration ==> Security ==> Permissions
Data Management ==> Data Sources ==> Metadata
Data Management ==> Data Sources ==> SAS Data Sets/Tables
|
| Date Modified: | 2009-11-19 10:08:07 |
| Date Created: | 2009-10-19 10:15:07 |
