Search results for query: *

We have a database that has several applications accessing data from it. We want to clean up the privileges that had been assigned to the public role when the developers created those apps by reassigning them to application roles all users of the apps will belong to. we aren't taking any...

Is there a guest user in Oracle similar to that of MSSQL? If not, is there a guest equivalent? Thanks!

hello... I am new to db2 and am trying to understand its general structure... (How does IBM term the structure... is an instance of db2 one database with many tablespaces / tables... sort of like oracle... or is it more like SQL server with many dbs in one instance with many tables per db? I...

hello... I am new to db2 and am trying to understand its general structure... (How does IBM term the structure... is an instance of db2 one database with many tablespaces / tables... sort of like oracle... or is it more like SQL server with many dbs in one instance with many tables per db? I...

Do anyone know whether there are any stored procedures in ASE that PUBLIC has access to that would grant them access to data in a user database that a user doesn't have permissions to view?? In other words, can a user with no privileges to view information in a user-defined database be granted...

is it possible to assign a user defined role to the PUBLIC role? and if so, is there a simple way to check that? I have seen this in oracle and informix but cant find anything on it with SQL server.

if i have a view thats base table is local, but has columns from a remote table. PUBLIC has been granted VIEW to to all local and remote tables. Will the PUBLIC's permission to the remote table be represented if I check the permissions to the remote table? try to read that 5 times fast. :) Thanks!

Is there a way to determine if a privilege granted to a role (for example: PUBLIC) is default to the system, or if it has been explicitly granted by a DBA? I have seen the isMSshipped property, but haven't found much of a description about it. Does it address the above question? Thanks!

Hello, Can anyone provide me with some insight or further documentation on the PUBLIC role within Oracle. I am new to Oracle. Is the role architecture in Oracle similar to that of SQL server? (Multiple DBs with in Oracle. Each DB with their own roles defined differently. Users assigned to...

Hello, I am trying to find any additional information about the PUBLIC role in Db2 with regards to it's default ability to access user data in the various databases on the server. Can anyone provide an area with which i should look, or documentation that would be helpful? Thank you in advance!

Hello! I am looking for a detailed explanation of the PUBLIC role within SQL server 2000. Is it possible to have a PUBLIC role within a DB in SQL server, provide access to the users in that DB to another DB on that server? Do any of the system tables or stored procedures the PUBLIC role has...