[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 560
  • Last Modified:

Access to tablespace

Have  a tablename 'customerinfo' in  tablespace Customer.   I want to grant  user  "TestCustomer"  read only access to  tablename 'customerinfo' in tablespace name  Customer.  Any inputs?
Nana Hemaa
Nana Hemaa
  • 3
3 Solutions
slightwv (䄆 Netminder) Commented:
grant select  on customerinfo to "TestCustomer";

tablespace has nothing to do with this.
first, the tablespaces have no impact on the grants for the table

to grant the privilege, log in as the table owner (or dba or similar privilege user) and execute the following...

grant select on customerinfo to testcustomer;
slightwv (䄆 Netminder) Commented:
If you have a lot of tables or users, I would create a readonly role and grant select on the tables to that role.

Then you can grant readonly to the users that need it.
Nana HemaaAuthor Commented:
How do i create the readonly role.? Tried doing it via EM but could not locate the readonly role.
slightwv (䄆 Netminder) Commented:
>>Tried doing it via EM but could not locate the readonly role.

You create it:  create role readonly;

then:  grant select on customerinfo to readonly;
grant readonly to  "TestCustomer";

I shoudl also hope you aren't using double quotes on your users and other object names.  This forces case sensitivity.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now